Google Apps Script (GAS) is a JavaScript cloud scripting language that lets you extend Google Apps and build web applications.
3
votes
2answers
189 views
How can I make some data Autosort in a spreadsheet on edit?
I am working with a simple spreadsheet that has name/lastnames in it. I need for the spreadsheet to automatically sort the entry alphabetically by the last name (column B).
I have used the following ...
2
votes
1answer
1k views
How do I mail merge from Google Spreadsheet to a Google Document?
With Microsoft Excel and Microsoft Word, it is easy to merge rows from a spreadsheet into pages in a Word file. This was traditionally used to make paper mailings. How can I do the same with Google ...
2
votes
0answers
168 views
Cumulative Sum without Script
For this question, I've created a Google Apps Script function, that calculates the cumulative sum of a range. Martin Hawksey on Google+ made a comment about a more efficient way of calculating the ...
3
votes
1answer
275 views
Creating a function that runs when a Google spreadsheet is opened
I want to create a function which runs automatically when the spreadsheet is opened. This function will make the selected cell the last cell without text in a certain column. Basically, I don't want ...
3
votes
1answer
465 views
Auto create and name new sheet in Google Spreadsheet
How can I automatically create and name new sheets in a google spreadsheet from a list of names, such as a student roll sheet? I would like each new sheet to be created when I add corresponding names ...
1
vote
1answer
454 views
Is it possible to pull my Company directory into Google sites intranet?
We use Google apps for enterprise, and I want to build an intranet, based on the Google sites intranet template
In the Directory area, I want that the list will be updated from my contact/company ...
0
votes
1answer
64 views
How do I Sum Thoughout Different Sheets
How do I create a reference to a defined interval in several sheets?
Something like this: =SUM(Sheet1:Sheet2!A1)
