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