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 principle. 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()

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

=?DO_EVERY(B2,1000)

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

Try it now

Previous – Action cellsExample of DO() and DO_PARALLEL()Next – Define behaviorRespond to clicks and keystrokes