ONCE
Returns the value of the inner formula and only executes once, turning the cell into a value
Syntax
ONCE(inner_formula)
Arguments
| Argument |
Description |
Required |
inner_formula |
Any valid formula you'd like to evaluate |
Required |
Examples
Calculate current date once
=ONCE(TODAY())
Result ⇒
Fixed date value
Generate random number once
=ONCE(RAND())
Result ⇒
Fixed random value
Calculate sum once and freeze result
=ONCE(SUM(A1:A3))
Result ⇒
60
Related Functions
Other Special functions:
- ONCHANGE - Returns initial_value until the range changes, then returns value_after_change and converts the cell to a static value
- TAGS - Converts a table with headers and rows into a JSON object array. There should be a "label" column and each row is rendered as a hoverable tag with that label.
← Back to Formula Reference