Learn
No results for 'undefined'
    Powered by Algolia

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

    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

    Sorry, your browser is not supported. MINTDATA™ works best on Google Chrome 50.0+ and Firefox 44.0+.
    Contents