This guide shows how to use formulas in the #Grid Custom Field# .
Let's create the formula column:
Prerequisites: configured gird and columns. You need columns to create formula expression.
Add a new column to the grid, using formula column type
- Input column's details:
Column type - select Formula type.
Identifier - a unique variable to identify the column. Required field - you can set the desired value here.
Title - column title, displayed in the grid.
Column IDs - list of existing columns' IDs. Use in order to create a formula.
Summary Label - label name, that will be used in the column summary.
Aggregation operation - select aggregation operation of the column data: sum, average, min/max, and count.
Input the formula, based on the grid columns' IDs.
Use column IDs in the formula expression.
- Save changes.
Congratulations! You just created your first formula. Now you can use formulas in the Table Grid Editor for JIRA Cloud.
Check more examples on the formula configuration page.