This page describes formulas functionality in the Table Grid Editor for Jira Cloud.
Formula column type
Error types in the formula column type
You can get the error as a result of the formula execution using following error types:
#error - syntax error
#type operation error - operation could not be executed using different column types.
Formulas as an aggregation function
You can use formula as an aggregation operation in other columns.
It provides you the flexibility to operate grid data in different ways.
This feature is available for all column types, supported by the Table Grid Next Generation for Jira Cloud.
In order to display formula result in the grid column input JS expression in the formula expression configuration.
You can do following operations using formulas:
mathematical operations with numbers:addition, subtraction, multiplication, division;
date subtraction - it's possible to use Moments.js library;
To run the formula when columns have empty values check the checkbox in the column configuration as below.
If you want to make the column values searchable - enable the Index data checkbox.
Use return as a keyword to get the formula result.
Userlist in formula
Use the following example to display Userlist column type in the formula