Supported functions for formulas
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 let you display calculated data directly on your Jira work items. Read more about formula fields and how to create one
You can create a formula using fields from your Jira space and any of the supported functions or operators listed below.
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 and C, or any other work item.
How to write a formula
The format for writing a formula is FUNCTION_NAME(parameters) where FUNCTION_NAME is the name of the function being called, and parameters is a comma-separated list of parameters as inputs to the function.
The parameter list can include any combination of number field references, integers, or another expression which itself may include a function call. Fields can be referenced by enclosing them in curly brackets. For example, MIN({Project Cost}, 30 * MAX({Day Rate}, 100)
Supported functions for formulas
The following functions are supported for custom formula fields in Jira:
Function | Name | Description | Example |
|---|---|---|---|
| SUM | Calculates the result of adding values together. | Let’s say you have field1 with the value of 6 and field2 with the value of 10. The formula SUM({field1}, {field2}) would return a value of 16. |
| AVG | Calculates the average of values. | Let’s say you have 3 fields: field1 has a value of 3, field2 has a value of 5, and field3 has a value of 7. The formula AVG({field1}, {field2}, {field3}) would return a value of 5. |
| MAX | Returns the highest value from selected fields. | Let’s say you have field1 with a value of 20 and field2 with a value of 18. The formula MAX({field1}, {field2}) would return a value of 20. |
| MINIMUM | Returns the lowest value from selected fields. | You have field1 with a value of 20 and field2 with a value of 18. The formula MIN({field1}, {field2}) would return a value of 18. |
| DIVIDE | Calculates the result of dividing values by other values. | Maybe you have field1 with a value of 6, and field2 with a value of 2. The formula DIV({field1}, {field2}) would return a result of 3. |
| MULTIPLY | Calculates the result of multiplying a value by other values or specified numbers. | Maybe you have field1 with a value of 2, and field2 with a value of 3. The formula MULTIPLY({field1}, {field2}) would return a result of 6. |
| MINUS | Calculates the result of subtracting values or specified numbers from a value. | Say you have field1 with a value of 12, and field2 with a value of 3. The formula MINUS({field1}, {field2}) would return a result of 9. |
| POWER | Calculates a value raised to a specified power. | Maybe you have field1 with a value of 9, and you want it raised to the power of 1.5 The formula POWER({field1}, 1.5) would return a result of 27. |
| ROUND | Rounds a value to a specified number of decimal places. | Say you have field1 with a value of 35.7845, and you want it rounded to 3 decimal places. The formula ROUND({field1}, 3) would return a result of 35.785. |
| ROUNDUP | Rounds a value up to a specified number of decimal places. | Say you have field1 with a value of 35.784, and you want it rounded up to 2 decimal places. The formula ROUNDUP({field1}, 2) would return a result of 35.79. |
| ROUNDDOWN | Rounds a value down to a specified number of decimal places. | Say you have field1 with a value of 35.784, and you want it rounded down to 2 decimal places. The formula ROUNDDOWN({field1}, 2) would return a result of 35.78. |
| FLOOR | Rounds a value down to a specified multiple. | Let’s say you have field1 with a value of $8.8037 and you want to show it rounded down to the nearest multiple of 5 cents. The formula FLOOR({field1}, 0.05) would return a result of $8.80 |
| CEILING | Rounds a value up to a specified multiple. | Let’s say you have field1 with a value of $8.8037 and you want to show it rounded up to the nearest multiple of 5 cents. The formula CEIL({field1}, 0.05) would return a result of $8.85 |
| ABSOLUTE | Calculates the absolute value (distance from 0) of a value. | You have field1 with a value of -8. The formula ABS({field1}) would return a result of 8. |
| ODD | Rounds a value up to the nearest odd number. | Say you have field1 with a value of 35.784 The formula ODD({field1}) would return a result of 37. |
| EVEN | Rounds a value up to the nearest even number. | Say you have field1 with a value of 35.784 The formula EVEN({field1}) would return a result of 36. |
| SQRT | Calculates the square root of a value. | Say you have field1 with a value of 9. The formula SQRT({field1}) would return a result of 3. |
Supported operators for formulas
The following operators are supported for formula fields in Jira.
Mathematical operators
+for addition-for subtraction*for multiplication/for division^for exponentiation (e.g. raising one number to the power of another)
Was this helpful?