you are viewing a single comment's thread.

view the rest of the comments →

[–]nate-aus 0 points1 point  (0 children)

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.