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.