Question
I want to create or adjust a formula in my structure.
Answer
Based on your setup and the formula’s requirements, you might find useful information for creating the formula you need in these materials:
-
some examples of already working formulas: https://help.tempo.io/structure-dc/latest/sample-formulas
-
check for bundled formulas inside Structure - maybe you’ll find one that can work for you right away or after some tweaking: https://help.tempo.io/structure-dc/latest/bundled-formulas
-
available standard functions - these functions can be used for creating custom values based on each item’s own data: https://help.tempo.io/structure-dc/latest/expr-function-reference
-
available aggregate functions - these functions can be used for summing up/rolling up the data across the levels of the hierarchy, or for creating custom values of parent items based on the data of their children: https://help.tempo.io/structure-dc/latest/aggregate-function-reference
-
item properties - these functions can extract additional data tied to certain field values in Jira (e.g. dates of Sprints, worklog authors, various properties of links etc): https://help.tempo.io/structure-dc/latest/item-property-reference
-
formatting with Wiki markup for adding visuals to the column - coloring, images, and emojis: https://help.tempo.io/structure-dc/latest/wiki-markup-in-formula-columns
If a formula you created doesn’t return the expected values or there is an error, you can:
-
debug it to get more insights into how exactly the values are being calculated in each item: https://help.tempo.io/structure-dc/latest/debugging-a-formula
-
check our guide on what particular errors mean, and how to tackle them: https://help.tempo.io/structure-dc/latest/expr-error-codes