Condition operators in calculated custom fields
You can use condition operators or modifiers when building calculated custom data in Adobe Workfront when using text mode. For information about using text mode in Workfront, see Text Mode overview.
Condition operators or modifiers help build a condition statement by connecting existing Workfront fields in statements and generating a new field. The most common use of condition operators is to build the condition of an “IF” statement.
You can use “IF” statements in Workfront to compare, format, and string together fields of data for both reporting and custom data purposes.
You can build “IF” statements for the following Workfront elements:
- Views
- Groupings
- Calculated custom fields
For more information about building “IF” statements, see “IF” statements overview.
The examples in this guide illustrate the use of condition operators in calculated custom fields. You can also use them in calculated custom columns or groupings as well, when following the correct syntax for calculated custom fields in reports.
For information about the difference in syntax between the calculated custom fields and calculated custom data in reports, see Calculated custom fields vs. calculated columns.
Refer to the API Explorer to find the fields you want to reference in your calculated custom expressions. For information about the API Explorer, see API Explorer.
You can use the following condition modifiers in Workfront:
Use this operator to indicate that the condition is fulfilled when the first field of your statement is equal to the second field.
For example, use the following statement in a calculated custom field to build an "IF" statement that compares the Planned Completion Date to the Projected Completion Date of a task:
IF({projectedCompletionDate}={plannedCompletionDate},"On Track","Off Track")
Use this operator to indicate that the condition is fulfilled when the first field of your statement is greater than the second field.
For example, use the following statement in a calculated custom field to build an "IF" statement that compares the Planned Completion Date to the Projected Completion Date of a task:
IF({projectedCompletionDate}>{plannedCompletionDate},"Late","")
Use this operator to indicate that the condition is fulfilled when the first field of your statement is either greater than or equal to the second field.
For example, use the following statement in a calculated custom field to build an "IF" statement that compares the Planned Completion Date to the Projected Completion Date of a task:
IF({projectedCompletionDate}>={plannedCompletionDate},"Late","Early")
Use this operator to indicate that the condition is fulfilled when the first field of your statement is lesser than the second field.
For example, use the following statement in a calculated custom field to build an "IF" statement that compares the Planned Completion Date to the Projected Completion Date of a task:
IF({projectedCompletionDate}<{plannedCompletionDate},"Early","")
Use this operator to indicate that the condition is fulfilled when the first field of your statement is lesser than or equal to the second field.
For example, use the following statement in a calculated custom field to build an "IF" statement that compares the Planned Completion Date to the Projected Completion Date of a task:
IF({projectedCompletionDate}<={plannedCompletionDate},"Early","Late")
Add this operator in front of any of the above operators to negate the operator.
For example:
- Equals: =
- Does not equal: !=
Adding this operator in front of the following data expressions adds a negative statement to expressions:
- CONTAINS
- IN
- IFIN
- ISBLANK
For information about these data expressions and for a complete list, see Overview of calculated data expressions.
Use this operator to indicate that the condition is fulfilled when the expression finds either the first or the second value of your statement.
For example, use the following statement in a calculated custom field to build an "IF" statement that marks projects in either the Current or Planning statuses as "Active":
IF({status}="PLN"||{status}="CUR","Active","Not Active")
Use this operator to indicate that the condition is fulfilled when the expression finds an item that fulfills two conditions at the same time.
For example, use the following statement in a calculated custom field to build an "IF" statement that finds projects that are in Current status and have a Condition of At Risk and marks them as "Mediation Needed."
IF({status}="CUR"&&{condition}="AR","Mediation Needed","")