Create a formula field
This feature is currently available as a beta experience in team-managed spaces. Additional functionality, plus support for company-managed spaces, is coming soon. Read more about what’s coming
Formula fields enable you to display calculated data directly on your Jira work items. Instead of manually calculating numbers or tracking information in spreadsheets, you can create custom fields that automatically calculate and display data using fields within a work item.
With formula fields, you can:
Add, subtract, multiply, and divide number fields or integers.
Calculate the average, maximum, minimum, power, and absolute value of any number field.
Round numbers up or down to a specified decimal, or to the nearest whole number.
Create a new formula field
Create a field via your space field settings:
Next to your space’s name in the sidebar, select More actions (), then Space settings.
Select Fields in the sidebar.
Select Add field, then select Create new field.
In the Field type dropdown, select Formula.
Enter a field name and description.
Enter a formula. View the list of supported fields and functions for formulas.
Select Format to choose how to display the formula’s output (as a number, currency, or percentage).
Select Create field to finish.
A formula can only run using data within a single work item. For example, a formula field on work item A can only calculate the sum of costs already shown on work item A. It can’t calculate costs across work items B or C, etc.
You can also create a field via a work item:
Select any work item.
From the Details section, select Edit fields (), then Create fields.
You must have space admin permission to create new fields in team-managed spaces.
Edit a formula field
To edit a formula field:
Next to your space’s name in the sidebar, select More actions (), then Space settings.
Select Fields in the sidebar.
Find the formula you want to edit and select More actions () then Edit field.
Update the formula, then select Save.
Delete a formula field
To delete a formula field:
Next to your space’s name in the sidebar, select More actions (), then Space settings.
Select Fields in the sidebar.
Find the formula field you want to delete and select Actions (), then select Remove field.
Select Remove field to confirm.
Was this helpful?