Run cells based on an interval

By using the DO_EVERY() function, you can run one or more action cells every time period (in milliseconds).

The example below just shows how the DO_EVERY() function works. In practice, this function is used to define the behavior of your application, which also requires linking a user action, such as a mouse click or a keystroke, to running an action cell with the DO_EVERY() function.

As an example, in cell B2, create an action cell with the RANDOM() function, like so:

=?RANDOM()
Copy to clipboard

In cell B1, use the following formula to run RANDOM() in cell B2 every second:

=?DO_EVERY(B2,1000)
Copy to clipboard

When you click on cell B1, the timer starts and the value in cell B2 starts changing every second.

Try it now

Contents