UPDATE
Updates the content of a widget.
Syntax
UPDATE(widget)
widget - the widget which should be updated - Value type: widget reference
Remarks
After calling UPDATE for a widget, the Content formula is executed to calculate the new widget content.
Example
In this example, cell1 is calculated with the RAND function. Every time the "UPDATE" button is clicked, cell1 is filled with a new random number.