Standard
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 forum.
Selected options:
Every hour
Every day 08:00
Every Monday 08:00
Every Tuesday 08:00
Every Wednesday 08:00
Every Thursday 08:00
Every Friday 08:00
Every 1 of month 08:00
[optional] timezone
The schedules
's UTC+HH:MM or GMT+HH:MM timezone. For example: "UTC+05:30"
. The default is UTC.