SCHEDULE

Schedule tasks to be executed at regular intervals.

Parameter List

Syntax
SCHEDULE(taskschedule
[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 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.

Examples

SCHEDULE(NOW(), "every 1 minutes") returns the current time, repeated every 1 minute.