Using Formulas or Conditions in Queries
For queries, you can evaluate the data before retrieving it from the database to determine whether or not 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 you can use in a query.
See Also
Assignee Filter Query Condition
Query Based Data Element (QBDE)
In This Section
Last Published Wednesday, December 20, 2023