Formula

The formula provides a convenient way to automatically calculate and display values in the table based on user-defined parameters. The values are calculated based on a preconfigured formula. The formula can be set up to use values from other numerical columns or select list columns.

Supported arithmetic operations:

addition “+”
subtraction “-”
multiplication “*”
division “/”

Formula column configuration dialogue

Index for search

By default, formula values are not searchable via JQL. In order to see column data in issue search results, values should be stored in issue properties. This feature is enabled in ‘Manage Formula dialogue’ by marking the checkbox ‘Store value in the properties for the index search’.

Conditional operations in formula columns

The formula column supports two types of conditional logic:

if(condition, valueIfTrue, valueIfFalse),
iff(condition, valueIfTrue; condition2, valueIfTrue2; ..., defaultValue)

if(condition, valueIfTrue, valueIfFalse)

Returns one of two values depending on whether the condition is true or false.

Use this when only one condition and two possible outcomes are needed.

Function structure:

condition – a statement that evaluates to a number (0 or non-zero).
valueIfTrue – returned if the condition is true.
valueIfFalse – returned if the condition is false.

How it works:

A condition that evaluates to 0 is considered false
A non-zero value is considered true
If true → returns valueIfTrue
If false → returns valueIfFalse

Example

Select list column is created, with options A, B, and C configured.

Requirement: formula column needs to return 10 if option A is selected, otherwise 0.

if(
  compare("select_list_column", 'A') == 0,
  10,
  0
)

Result:

If option A is selected → returns 10
Otherwise → returns 0

iff(condition1, result1; condition2, result2; ..., defaultResult)

Short for “if and only if”, this is used for multiple branching conditions.

Use this logic when you want to check multiple conditions in order or need to simulate switch/case logic.

How it works

Conditions are checked in order, from top to bottom.
As soon as one condition evaluates to true (non-zero), its result is returned.
If no condition matches, the final value is returned as default.

Example

A select list column is created, with options A, B, and C configured.

Requirement: formula column needs to return values based on what’s selected in select list column:

10 if option A is selected
20 if option B is selected
30 if option C is selected
0 if anything else is selected

iff(
  compare("select_list_column", 'A') == 0, 10;
  compare("select_list_column", 'B') == 0, 20;
  compare("select_list_column", 'C') == 0, 30;
  1 == 1, 0
)

AND condition

To combine multiple conditions with AND, use multiplication *.

All conditions must evaluate to true (i.e. equal to 0 in compare() logic) for the result to be applied.

iff(
  (compare("select_list_column", 'A') == 0) * (compare("select_list_column2", 'a') == 0), 10;
  compare("select_list_column", 'B') == 0, 20;
  1 == 1, 0
)

OR condition

To combine multiple conditions with OR, use addition +.

At least one condition must evaluate to true.

iff(  
((compare("select_list_column", 'A') == 0) + (compare("select_list_column2", 'a') == 0)) > 0, 10;  
compare("select_list_column", 'B') == 0, 20;  
1 == 1, 0)