New answers tagged


Another common use case is that you want to link to a particular cell/range, but the data may be sorted, added and filtered and your reference will be lost. You can work around this by creating a view and linking within a view. Steps: Create a new view that you would like to use. Remove all filters and sorts (or set some default sequential sort where ...


It looks like this feature wasn't around when this question was asked, but things have definitely changed :) source


I am using the below script for asking the user input and it creates a new sheet from the template with all formatting and protections with the name from the input. It will copy the variables in the sheet. You can customize it easily to save the names in another sheet. function new_order() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var idno = ...


Once I enter a name in Column A I'd like a new Sheet automatically created with pre-set columns function onOpen() { SpreadsheetApp.getUi().createMenu('My Menu') .addItem('Create New Tabs', 'createTabs') .addToUi()} function createTabs() { var ss = SpreadsheetApp.getActive() ss.getSheetByName('SheetXX').getRange('A:A').getValues()....

Top 50 recent answers are included