Tag: spreadsheet

I am having trouble getting this for loop to work correctly: I have a sheet named “0” and another named “100” and so on (dependent on how many sheets are in the spreadsheet). The script works for the first sheet (i.e. finds the sheet named “0”): But it returns a “TypeError: print_ss.getSheetbyName is not a function” for the following line:

How to make automatically delete rows with multiple sheet in google script based on trigger, I’ve used this script and it worked, but I want this script to be able to use two or more tab sheets at once while the current script only uses one tab sheet. how to use more than one tab sheet in getSheetByName? Can anyone

I am trying to automatically hide a sheet called “Add expense” when I am not active on it. For example. I have the sheet “BD Expenses”, the sheet “BD Tokens”, the sheet “BD Income”, the sheet “Add expense”, the sheet “Add income”. What I want is that when I am active in any of the sheets that is not called

I want to create a script which should use everytime the newest sheet. The sheet gets updates from another group and I want to create an email alert, if I have something to do. Everytime this spreadsheet get an update from another team, they create a new sheet with name of the date (TT.MM) and make the old one invisble.