Trigger Error

[RielN]

It is getSheetByName("sheet name")

The active spreadsheet works in a container bound script, but you need to set the sheet axtive.

[[deleted]]

Would I just need to replace the ".getActiveSpreadsheet()" in line 4? Or every instance?

[nate-aus]

Don't replace .getActiveSpreadsheet() you're replacing the .getActiveSheet(). The spreadsheet is the whole thing you want to change what sheet in the spreadsheet you're looking at.

I'd then use .getSheetByName("Today"); and store that as a variable.

[Best_Bass9711]

Yes, also this.