This can be super useful: How to create a PDF in your Google Drive of a specific sheet. Important notes: • The token is necessary ie var token = ScriptApp.getOAuthToken(); • All the parameters can be changed to suit your needs Sheet (to copy) https://docs.google.com/spreadsheets/…​ Script: read more

How to automatically place a static date, datetime, or timestamp with an edit. Important note: • I have included all 3 scripts in the editor. Uncomment out the one you want, as they cannot all work simultaneously. Sheet (to copy): https://docs.google.com/spreadsheets/d/1_9Q_bP79nGnETz25q-8J1NrIxxd2muqqz8ej3fCjDhw/edit#gid=0 Scripts: /* Sheet3 multiple read more

How to QUERY() with a column for the sheetname, or sheetnames from multiple sheets. Important note: * In the custom array {}, use commas to separate columns and semicolons to separate rows Sheet (to copy): https://docs.google.com/spreadsheets/d/1Q0kAwUQkj9i3M3qJMUX9_Fwgkaeo7cc26TRhW0irnIo/edit#gid=1970274019 Formula: =QUERY({ ARRAYFORMULA(IF(LEN(‘Location 1′!A2:A),”Location 1″,)),’Location 1’!A2:B; ARRAYFORMULA(IF(LEN(‘Location 2′!A2:A),”Location 2″,)),’Location read more