You want to repeat an action regularly in a spreadsheet? You can now do it without any add-ons or plug-ins or scripts.
=REPEAT(expression, interval, [start_time]).
- Expression - the expression to be recalculated periodically.
- Interval - the time interval in whole minutes that will lapse between value changes. The minimum value is 1 minute, the maximum value is 43200. Example: 1440 for daily repetition.
- Start time (optional) - the time in minutes that will pass before the first execution of the timer. Any decimals are ignored.
Returns value: Returns value of Expression every time it recalculates according to Interval and Start time. In the example, returns a time stamp that updates every 1 minute. If you want to start the first execution only after one hour, the example would be adjusted to