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. See Column Constraints.

  • 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

  • In a virtual column: CONCATENATE([FirstName], " ", [LastName])

  • In a slice filter condition: [Status] = "Complete"

  • In a Valid_If column constraint: [_THIS] > 25

Did this answer your question?