The value of this read-only custom field is calculated automatically using a custom math or numeric expression.
You can use it to generate a number based on the values of other fields in the current work item or in related work items (such as linked issues, sub-tasks, epics, stories, or issues returned by a JQL query).
Create a custom number formula field
Choose the template
Just like for any other formula field, follow the steps outlined here: Create and configure formula fields and select the Custom number formula field template in the field creation assistant.
Once selected click on Next.
Provide the expression
Creating an expression from scratch might feel like a challenge, especially if you are not familiar with our expression editor (known from our app Jira Workflow Toolbox). But we have you covered!
Either start by looking at the built-in example expressions or browse through the use cases and examples we have collected for you at the bottom of this page.
Preview the output
Once you have provided the expression you can preview and validate the output by selecting an existing work item.
Number format pattern
If your formula field is being used to store a simple number (e.g. a dollar amount), you have the option to display the value just like you would expect it - by applying a custom Display formats.
You can even use emojis like 💵 💶 ⭐️ when selecting a custom format!
📚 Use cases and examples
| Use case | Parsing mode | Expression |
|---|---|---|
| Number of sub-tasks based on status and work item type |
General |
|
| Sum of field values from work items in JQL query |
General |
|
| Difference between the current day and the earliest sub-task due date |
General |
|
| Sum of field values from sub-tasks |
General |
|
| Number of times that a custom field has been changed |
Jira expression |
|
| Count labels |
General |
|
| Completion percentage by status |
General |
|
| Number of sub-tasks based on status |
General |
|
| Priority assessment based on field values |
General |
|
| Multiply and sum field values from sub-tasks |
Jira expression |
|
| Total original estimate of blocking work items |
General |
|
| Time since creation |
General |
|
| Sum completed sibling items’ story points |
General |
|
| Average time since creation of sub-tasks |
General |
|
| Number of characters in a field |
General |
|
| Remaining budget - expenses tracked in sub-tasks |
General |
|
| Sum of time spent on blocking work items |
General |
|
| Count frequency of a keyword in social media content |
General |
|
| Highest value out of several fields |
General |
|
| Sum of time spent on epic and child work items |
General |
|
| Total remaining estimate of blocking work items |
General |
|
| Sum of time spent on work items with same fix version |
General |
|
| Time left until due date |
General |
|
| Elapsed time between creation and resolution |
General |
|
| Days until due date |
General |
JavaScript
|
| Number of work items with the same fix versions |
General |
|