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

You can also learn more about other types of expressions.

Column 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 Expression

Common Use Cases

Did this answer your question?