Structure formulas advanced

Ready to level up? Structure formulas can do much more than a just a single-item calculation.

It can aggregate metrics across children and subtrees, evaluate relationships between issues, and apply conditional logic that adapts to the shape of your data. Join our product experts on October 29 at 11:00 am ET for part 2 of our formula webinar series, where we take Structure's built-in scripting language to the next level.

In this session, we'll take formulas beyond the basics - unlocking advanced techniques that help you manage complex projects more effectively and make better-informed decisions. 

We will cover:

• How to use nested conditionals and local variables to efficiently automate risk and priority scoring. Basic and advanced calculations based on issue fields, item properties, or other attributes

• How to use Wiki Markdown to create custom progress bars and visual warning badges. Values comparison from multiple fields 

• Calculating time-in-status, measuring cycle times, and tracking scope creep through historical field changes. Managing issue relationships and dependencies

• Powering Gantt Chart timelines using formula columns for custom dates, schedule variances, and progress metrics. Creating visual notifications based on various conditions using Wiki markdown language

• Rolling up Timesheets and Planner data to compare planned vs. actual time and track team capacity.

This session builds on part 1 - Structure Formulas Unlocked, so some familiarity with Structure formulas is recommended.