Column value expressions

Write an expression to get a value from a specific column and row

Column value expressions return the value of a specific column in a row. The row itself does not need to be specified; it's usually implicit in the context of the expression.

  • Name any column using square brackets around the exact column name: [ColumnName].
  • When used in a column constraint (Editable_If,  Required_If, Show_If, or Valid_If), you can use [_THIS] to refer to the value of the current column of the current row.
  • If the current row is not implicit from the context of the expression, it must be explicitly specified using a dereference expressions

New to expressions and formulas? See Expressions: The Essentials.

Common use cases

Was this helpful?
How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center