Creating formulas in Structure

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:

1. Some examples of already working formulas: https://help.tempo.io/structure/latest/sample-formulas
   You might find a formula that you need there, or a similar formula that can be used as a base, and adjusted with your specific data.

2. 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
   These functions can be directly used with numeric, text, date & date/time, and duration types of values.

3. 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

4. Item properties - these functions can extract additional data tied to certain field values in Jira: https://help.tempo.io/structure/latest/item-properties
   With these properties, you can display properties such as: Start & End dates of Sprints; Component lead; authors, and posting dates of Comments; attributes of worklogs: authors, dates, logged hours of specific users in specific time periods; historical data of work items, and more. Also, the properties of the issuelinks allow filtering through linked work items and extracting some data from linked items.

5. Formatting with Markdown for adding visuals to the column - coloring, images, and emojis, and highlighting certain values in the way you need: 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

If you still need assistance after exploring the materials mentioned above, please let us know, and we will look into it. Please describe what you want a formula to display as a result, as well as screenshots of your structure.

It’s often impossible to provide any recommendations without understanding the context around the formula, so please make sure to provide as many details as possible: about the formula you need and the data you want to use for calculation, and the description of your setup.