1. How to fix 'Invalid argument: timeZone. Should be of type: String'?
- Open your Google Sheet.
- Go to File > Spreadsheet settings.
- In the "General" tab, find the Time zone setting.
- Change the time zone to a different one, then click Save settings.
- Go back to File > Spreadsheet settings. Change the time zone back to your desired, correct time zone (e.g., "America/Vancouver" or a nearby city with the same offset).
- Click Save settings again.
This process forces the system to re-validate and update the time zone setting, which usually resolves the "Invalid argument" error.
Hi, is it possible to have a task for weekdays only instead of daily?
ReplyDeleteYes, on frequency column, please enter d to repeat task on weekdays only. For daily including weekend, please enter 1d.
DeleteAlso, can this write to a "History" log (to track how many times/when a repeating task is completed)?
ReplyDeleteYes, a TDL log sheet is added.
ReplyDelete