Skip to main content

GETONCE

Calculates a value one time and then keeps that value fixed, even if the original inputs later change.

Description​

Normally, formulas update automatically when the data they depend on changes.
GETONCE is different: it runs the calculation once and then locks in the result.
Future changes to the input data will not affect the stored value.

This is useful when you want to capture a number at a certain moment in time (for example, a price, a timestamp, or an order ID) and prevent it from changing if the underlying data updates later.

Syntax​

GETONCE(expression)

Arguments​

  • expression: Any formula, value, or calculation that you want to capture once.

Examples​

GETONCE(SUM(A1:A10)))

→ Stores the sum of cells A1 to A10.The values will not update when the A1:A10 range changes later.

GETONCE(A1 * 1.2)

→ If A1 is 100, the result is 120.
If A1 later changes to 200, the GETONCE result will still be 120, because it was locked at the original calculation.

✅ When to use GETONCE

  • To capture an initial value (like a starting balance).
  • To generate unique identifiers (like order IDs) that should never recalculate.
  • ⚠️ Important: Because GETONCE does not track changes, you should only use it when you are sure you want the value to stay fixed.
  • When there are many hundreds or thousands of records connected to other data, but that data is not expected to change often. This can help improve performance by reducing the number of recalculations needed.