Using Formulas or Conditions in Queries
For queries, you can evaluate the data before retrieving it from the database to determine whether to include the value in the report, manager sheet, or data picker, or to spawn an auto-creation. To evaluate the data, you can use a formula or a condition.
In formulas, multiple fields can be calculated to arrive at a certain value that the data must meet before it will be used. The value can be one that you enter, or a value from another field.
You can include formulas in conditions.
In the Condition field, select the condition the value in the field must meet.
The following explains the formulas that you can use in a query.
In This Section
Last Published Tuesday, December 12, 2023