On this page
Field configuration
Before starting the field configuration, please follow the instructions for creating custom fields
Step 1: Set a name and description
Provide a good name for the new custom field. Make it descriptive, concise, and easy to understand for others who will use it. Avoid using ambiguous or overly technical terms.
Step 2: Add formula
The formula field facilitates custom calculations through:
Placeholders (e.g., {{fieldname}}) — Note that these are not Jira smart values.
Operators: addition (+), subtraction (-), multiplication (*), division (/), and parentheses (())
Number constants.
For instance, the formula ({{customfield_10342}} + 5) * 2 will be computed with the issues' field value of customfield_10342 (e.g. 8) to yield (8 + 5) * 2 = 26.
There’s an autocomplete to add field placeholders. Just write “{{“ and see recommendations.
Note that the number of allowed placeholder values is limited to 5.
Step 3: Setup output format, size and color based on value
The decimal toggle lets you switch between integer and up to two decimal places.
The field allows you to choose from a pre-defined set of field sizes.
You may also set different colors for different values.
Field view and edit
No edit mode
Values are derived from other issues' field values, and users cannot modify the calculation settings.
However, users can observe the calculation process. In this instance, the customfield_10342 (Advanced Number) with the value 8 is inserted into the formula.
On the other hand, users receive hints in case of an error to understand what went wrong.
In this case, the value of customfield_10342 (Advanced Number) is unset (None), and therefore, it can't be used for a calculation.
Not available in create issue
As you cannot edit the value manually, you can’t set it when creating a new issue. Better make sure it’s not displayed in the screen.
Preview
Related Use Cases
More use cases are coming soon. In the meantime, check out our other use cases.
Jira Service Management (JSM)
The Advanced Formula field is currently not available for Jira Service Management
JQL expression
The value is calculated just in time and saved as a field value, but there may be a delay in updating when a placeholder field value changes.
The sum field is an object type with a property Formula Result.
${fieldName}.Formula Result: number
Find further information here https://support.atlassian.com/jira-software-cloud/docs/find-specific-issues/
Example: a search for all issues with a calculation result greater than 5
"Advanced Formula.Formula Result" > 5
Data Structure (Automation)
As the value is calculated, we don’t recommend to edit it manually or by automation!
To set the value via automation, you need the following object structure
{
"value": number
}