You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I want to create a custom formula column in my structure so that it shows a running total of a issue field, like Planned Effort. A rough way to determine where to cut off to fit the maximum capacity.
Is there a way to create such a formula in the Structure?
Hi @Sam Li,
You could try the Issue Filter Formula or the Advanced Issue Filter Formula gadgets offered by our Great Gadgets app.
These gadgets allow you to calculate and display the result of a math formula against the field of the issues from a Jira filter.
In your case, create a Jira filter that returns that issues from the structure and then configure the gadget to calculate the SUM of Planned Effort field.
This app offers many other useful gadgets for project tracking. Just have a look over the articles from our blog to make an idea.
I hope this helps. If you need any help in configuring these gadgets, please don't hesitate to contact us at firstname.lastname@example.org.