LAMBDA(volatile, update, volatile)([volatile function], [update condition])

LAMBDA references only recalculate when a change is detected in a cell referenced by the formula. This property overrides the typical volatile property of updating whenever any cell is updated.

Because LUS is unstable, typical use cases relate to temporary randomization and dice rolling.

Like all volatile functions, LUS will cause a desynchronization between the server and client sheets. In order to load the canon server-side value, simply refresh your client.

Example

=LAMBDA(x,x)(RANDBETWEEN(1,10))

This RANDBETWEEN will not update on a cell change. Compare to:

=RANDBETWEEN(1,10)