Access requirements
Expand to view access requirements.
You must have the following access to perform the steps in this article:
*For more information about Workfront access requirements, see Access requirements in Workfront documentation.
Considerations about formula fields
-
Formula fields reference fields that belong to the same record type.
-
You can reference fields from other record types only when you connect another record type to the one you’re creating a formula field for.
-
You cannot change the Field type of a Formula field after you save it.
-
You can update the calculation of a formula field after you save it, and the results of the calculation update automatically for all the records of the same type.
-
You must add the fields you reference in formulas as they display in the Workfront Planning interface.
-
You can reference only fields that display in the table view of a record type or on the record details page.
-
You can define the format for the value of a formula calculation by choosing from the following format options:
- Text
- Number
- Percent
- Currency
- Tags
- Date
For more information, see the “Formula” section in the article Create fields.
Supported formulas
Adobe Workfront Planning formula fields support most of the expressions from the Workfront calculated fields.
- SORTASCARRAY
- SORTDESCARRAY
- ADDHOUR
- SWITCH
- FORMAT
For a complete list of Workfront expressions, see Overview of calculated data expressions.
In addition, we support the following expressions for Workfront Planning formula fields. The following expressions are not supported for Workfront expressions:
Expression | Explanation and example |
---|---|
ARRAYJOIN |
Returns concatenated string by delimiter. The expression is formatted as follows:
|
ARRAYUNIQUE |
Returns array with unique values. The expression is formatted as follows:
|
ID |
Returns the ID of a record. Each record has a unique ID. The expression is formatted as follows:
|
JSONELEMENT |
Returns the data from JSON by the provided JSONPath. If the JSONPath doesn't exist in the JSON, an empty result will be returned. The expression is formatted as follows: |
SETTIMEZONE |
Sets the timezone of a date and time to a specific timezone. The expression is formatted as follows:
|
WEEKOFYEAR |
Returns the week number in a year. Optionally, you can indicate which day the week starts on (use 1 for Sunday, or 2 for Monday). If omitted, weeks start on Sunday, by default. The expression is formatted as follows:
|