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 is quite straightforward.

Enter an arithmetic expression into the ‘Formula’ field. To pass validation column names must be quoted.

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’.