REPEAT

Repeat the calculation or execution of a function in a specified cell periodically.

Parameter List

Syntax
REPEAT(formula
[interval]
[unit]
[delay]
[unit]
)
formula

Formula to be refreshed periodically. For example: NOW().

[optional] interval

The interval between the formula repetitions. By default this is 1440 min (1 day). The minimum is 1 (min).

[optional] unit

The unit of time to use with the interval. Choose between:

  • "min" for minutes (default)
  • "h" for hours
  • "d" for days
  • "w" for weeks
  • "m" for months
Selected options:
days
hours
minutes
months
weeks
[optional] delay

The time until the first repetition. By default this is 1 (min). The minimum is 0 (min).

[optional] unit

The unit of time to use with the delay. Choose between:

  • "min" for minutes (default)
  • "h" for hours
  • "d" for days
  • "w" for weeks
  • "m" for months
Selected options:
days
hours
minutes
months
weeks
More details

The maximum interval for formula and delay is six months.

Examples

REPEAT(NOW(), 1, "min", 1, "min") returns executes the NOW() function with a delay of 1 minute and will repeated it every 1 minute.