Parameter List
Syntax
REFRESH(range,
[interval]
, [unit]
, [delay]
, [unit]
)range
Cell or range to be refreshed periodically. For example: A3 or B1:B6.
[optional] interval
The interval between cell or range refreshes. 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 refresh. 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 range and delay is six months.