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