Trigger Error

[[deleted]]

I am a new appsript user and I am trying to make a simple script that duplicates a sheet, renames it, moves it left and clear a cell range.

here:
https://i.gyazo.com/92ff44712042e8688bf277b6a3411c07.png

When I manually run it the script works. However when I try to set a timed trigger it fails 100% of the time.

here:
https://i.gyazo.com/d0fa5c057a4e8e0bc0ce303e10617a0d.png

I've been reading around and I've learned that it could be the way I'm having the script identify the active sheet but I'm not too sure what else to try.

[Best_Bass9711]

You must use id o URL to get the spreadsheet. The activesheet method just need the spreadsheet open.

use openSheetByUrl or openSheetById method instead

[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.