Parameter List
Syntax
SCHEDULE(task, schedule,
[timezone]
)task
The formula or cells to schedule. For examples: NOW()
, A1
, or B2:B7
.
schedule
When and how often to execute the task. For example:
"every 5 minutes"
, "every day 09:00"
, or "every tuesday,wednesday of march,april,may 18:00"
. For a detailed list of examples, see the Schedule entry on our documentation.
Selected options:
Every 1 of month 08:00
Every monday 08:00
Every day 08:00
Every hour
Every 10 minutes
Every minute
[optional] timezone
The schedules
's UTC+HH:MM or GMT+HH:MM timezone. For example: "UTC+05:30"
. The default is UTC.