This article is for Structure Cloud.
Question
I want to write a formula 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/latest/sample-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/latest/standard-functions
-
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/latest/aggregate-functions
-
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/latest/item-properties
-
formatting with Markdown for adding visuals to the column - coloring, images, and emojis: https://help.tempo.io/structure/latest/text-formatting-with-emojis-and-markdown
Alternatively, to create a formula that works for you, please feel free to try out our own Rovo Agent - the Formula Assistant: https://help.tempo.io/structure/latest/structure-formula-assistant