鈥淚F鈥 statements overview
You can use 鈥淚F鈥 statements in general programming languages. In 蜜豆视频 Workfront, 鈥淚F鈥 statements allow you to compare, format, and string together fields of data for both reporting and custom data purposes. Also, thinking mathematically about 鈥淚F鈥 statements leads to a better conceptual understanding since variables for expressions are commonly used.
Recommendations for 鈥淚F鈥 statements
Consider the following before creating an 鈥淚F鈥 statement:
-
We recommend a basic understanding of any general programming language, but we do not require it, for this guide.
-
We require an advanced understanding of the Workfront text mode syntax. This helps with grasping the terminology of the Workfront API and with understanding the syntax of custom data in these specific formats.
For information about the Workfront API, see API basics.
For information about using text mode, see Text Mode overview.
-
You can build 鈥淚F鈥 statements for the following Workfront elements:
- Views
- Groupings
- Calculated custom fields
-
You cannot build 鈥淚F鈥 statements for filters. This results in a 鈥淲hoops鈥 error in Workfront.
-
The Support Team does not help with building custom data. You can contact the Support Team after you build the custom fields or columns and you are not seeing the desired results. For help building an expression, please contact your Account Executive to inquire about our consulting options.
-
We recommend writing these expressions in a text editor first, such as Sublime or Visual Studio Code, because this helps you see data more clearly than would appear in Workfront.
Components of an 鈥淚F鈥 statement
You can build 鈥淚F鈥 statements in Workfront using the following format:
IF(Condition,True Expression,False Expression)
-
IF = This is the Workfront calculated data expression for 鈥渇unction.鈥 Similar to the SUM and PROD expressions, this first tells the system to understand the function as an 鈥淚F鈥 statement. Always use capital letters for 鈥淚F鈥 in this statement.
For a list of all calculated data expressions, see Overview of calculated data expressions. -
Condition = This is the condition that the Workfront variable must meet and it is the foundation for this equation. Everything that can be later specified in the equation depends on the condition. You can use a number of references, comparisons or mathematical expressions to start an equation. Some examples of conditions are:
- A date is greater than another date on a specified object.
- A status equals one of the available statuses on a specified object.
- Percent complete of a task is lesser than or greater than a certain percentage.
-
Condition Operator = this is the operator that helps you build the condition of your 鈥淚F鈥 statement. For example, 鈥渋s equal to鈥 or 鈥渋s greater than鈥 are condition operators. For a list of condition operators that you can use in statements, see Condition operators in calculated custom expressions.
-
True****Expression = This is the 鈥淭rue鈥 variable, which tells the equation which indicator to display once the criteria of the condition are met (true indicators).
-
False Expression = This is the 鈥淔alse鈥 variable, which tells the equation which indicator to display when the criteria of the condition are not met (false indicators).
In the following example, the original statement format is used to write a simple data expression for an 鈥淚F鈥 statement. The expression compares two different date fields in Workfront followed by a True/False result as a data string:
IF({projectedCompletionDate}>{plannedCompletionDate},"Off Track","On Track")
In everyday speech, this statement would mean: If the Projected Completion Date of my object is 鈥淕reater Than鈥 the Planned Completion Date of my same object, then display the words 鈥淥ff Track鈥 in this field. If not, display the words 鈥淥n Track.鈥
Build calculated fields in custom forms or custom columns using 鈥淚F鈥 statements
You can build 鈥淚F鈥 statements in a calculated field either in a custom form, or in a custom column.
There is a difference in the syntax you use in a calculated custom form vs a calculated custom column. Refer to the following examples:
Single 鈥淚F鈥 statements single-if-statements
The following are examples of a calculated custom field and its corresponding column using an 鈥淚F鈥 statement:
- Calculated custom field:
When building a custom field, use the following syntax for an 鈥淚F鈥 statement:
IF({Projected Completion Date}>{Planned Completion Date},"Off Track","On Track")
- Calculated custom column:
When building a custom column, you should use the following syntax for the 鈥淚F鈥 statement in the value expression line:
valueexpression=IF({projectedCompletionDate}>{plannedCompletionDate},"Off Track","On Track")
Multiple 鈥淚F鈥 statements multiple-if-statements
You can put together multiple 鈥淚F鈥 statements with the following statement to build a more complex and dynamic expression:
IF(Condition1,True Expression,IF(Condition2,True Expression,False Expression))
The following are examples of a calculated custom field and its corresponding custom column using multiple 鈥淚F鈥 statements:
-
Calculated custom field:
code language-none IF({projectedCompletionDate}>{plannedCompletionDate},"Off Track",IF({plannedCompletionDate}>{projectedCompletionDate},"Off Track","On Track")) -
Calculated custom column:
valueexpression=IF({"projectedCompletionDate"}>{"plannedCompletionDate"},"Off Track",IF({plannedCompletionDate}>{projectedCompletionDate},"Off Track","On Track"))
In this example, the same thing has been accomplished by putting two different criteria variables together.
You can further explore these options by rebuilding these examples in your own environment.
The best way to learn this is by experimenting with various fields and scenarios. Also, become familiar with the API Explorer, which reveals the field names that can be used. For information on the API Explorer, see API Explorer.
For more information about Workfront syntax of calculated data expressions, see Overview of calculated data expressions.