Spencer Speaks

How to update the formulas on Child sheets when the Parent or Template sheet is updated. Important Notes: * No script in this video should be ran manually * The script updating other Sheets files must be set on a trigger Sheets (Make a copy read more

Creating Calendar events from data in a Sheet. Important notes: * You must have write access to the calendar being accessed in order to use .createEvent() * A calendar can be retrieved as the default calendar, by ID, or by name. Calling by ID or read more

How to setup 2-way sync within the same workbook without any unique ID. Important notes: * This is the least efficient of the 3 methods, so I would suggest against it unless absolutely necessary Sheet (Make a copy from the File menu) https://docs.google.com/spreadsheets/d/1Pp1OvXNJjCK7nyBMS2g_Czg0-XjLXRNKVKWUlUZ4qLc Script: function read more

Setting up 2-way sync within the same spreadsheet where the ID and the row DO NOT have a mathematical relation. Important notes: * Remember to increment the /row/ variable after the loop * This assumes the FILTER()/QUERY()/IMPORTRANGE() etc. formula is already setup and functioning properly. read more

Setting up 2-way sync within the same spreadsheet where the ID and the row have a mathematical relation. Important notes: * This version only works when the ID and the row have a mathematical relation such that the row number can be derived from the read more

How to write a custom function and return the sheet names. Sheet (to copy from the File menu): https://docs.google.com/spreadsheets/d/19ismgyyfalmi3WedEH1fhs-_Zt8jP4v3QD9HRDUIDdo/edit Scripts: /** * Returns the name of the current tab. * @return Current tab name. * @customfunction */ function sheetname(){ return SpreadsheetApp.getActive().getActiveSheet().getName(); } /** * Returns read more

How to move all checked rows to another tab. Important notes: * Keep your math correct when iterating through the data array, deleting items from the Sheet, and deleting items from the array Sheet (to copy from File then “Make a copy”) https://docs.google.com/spreadsheets/d/1o-zBFV9Mqi5hngWhB9jK4xQNo4sMxrvWBemroUBMy5o/edit#gid=0 Script: function read more

How to run multiple onEdit events in the same script. Important notes: * It was not shown in the video, but you cannot have more than one function of the same name in the same script. * The actual events used in my Sheet are read more

How to create multi-select dropdowns in Google Sheets Important notes: * Don’t run the function manually, it will fail. * Make sure the row and column in the IF() statement match the cell/range you want to include the dropdowns * The red triangle at the read more