Formula fields overview
The highlighted information on this page refers to functionality not yet generally available. It is available only in the Preview environment for all customers. After the monthly releases to Production, the same features are also available in the Production environment for customers who enabled fast releases.
For information about fast releases, see Enable or disable fast releases for your organization.
- A new Workfront package and license. Workfront Planning is not available for legacy Workfront packages or licenses.
- A Workfront Planning package.
- Your organization’s instance of Workfront must be onboarded to the Adobe Unified Experience.
You can create custom fields in Adobe Workfront Planning by referring to existing fields and connecting them in a Formula-type field.
Formula fields generate a new value using existing values from other fields in a record type and a function that indicates how the existing values should be calculated.
For information, see the “Formula” section in the article Create fields.
Access requirements
| table 0-row-0 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 7-row-2 layout-auto html-authored no-header | |
|---|---|
| Products |
|
| Adobe Workfront plan* |
Any of the following Workfront plans:
Workfront Planning is not available for legacy Workfront plans |
| Adobe Workfront Planning package* |
Any For more information about what is included in each Workfront Planning plan, contact your Workfront account manager. |
| Adobe Workfront platform |
Your organization's instance of Workfront must be onboarded to the Adobe Unified Experience to be able to access Workfront Planning. For more information, see Adobe Unified Experience for Workfront. |
| Adobe Workfront license* |
Standard Workfront Planning is not available for legacy Workfront licenses |
| Access level configuration | There are no access level controls for Adobe Workfront Planning |
| Object permissions |
Manage permissions to a workspace and record type System Administrators have permissions to all workspaces, including the ones they did not create |
*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.
-
Referencing connected record types or their lookup fields in a formula depends on your permissions to the connected record types. If you have no permissions to view the record type, you cannot reference their fields in a formula.
-
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.
-
You can reference formula fields in new formulas. Once the value is updated in a field referenced in a formula field, all subsequent fields referencing that field or formula fields that contain that field will update automatically.
Limitations of formula fields
-
You can add a maximum of 20 formula fields for one record type.
Formula lookup fields added from connected record types do not count against this limit.
-
The formula expression cannot exceed 50,000 characters.
-
Formula fields might display as
#ERROR!in the following cases:-
When a field used in a formula is deleted.
-
When a field used in an aggregated lookup field displays as
#ERROR!.For example, if you display a lookup field that contains aggregated lookup formula fields and one of the referenced formula fields displays as
#ERROR!. -
When a formula value cannot be displayed in the selected format.
For example, if I select Number for the Format of a formula field, and the fields used in the formula are text fields that display only non-numeric text values, the formula result will display as
#ERROR!, because it cannot parse the text into a number.
-
Supported formulas
Adobe Workfront Planning formula fields support most of the expressions from the Workfront calculated fields.
- 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:
Returns concatenated string by delimiter.
The expression is formatted as follows:
ARRAYJOIN(delimiter,array)
Returns array with unique values.
The expression is formatted as follows:
ARRAYUNIQUE(array)
Returns the ID of a record. Each record has a unique ID.
The expression is formatted as follows:
{ID}
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: JSONELEMENT(JSONString, JSONPathString)
Sets the timezone of a date and time to a specific timezone.
The expression is formatted as follows:
SETTIMEZONE(date,‘America/Los_Angeles’)
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:
WEEKOFYEAR(date,2)
orWEEKOFYEAR(date)