Please help me on this.
I need to sum the original estimates of team, where i need to do this in formula in structure.
Hello @shyam prasad
Thank you for sharing your Structure Formulas question here on the Atlassian Community
You could try the below formula and see if it works:
SUM{if(OriginalEstimate != 'Empty'; OriginalEstimate)}
You would need to change the Format to Duration, by selecting it on the dropdown list right next to the "Options" field. Please refer to this article for more information - LINK
Please let me know if it helps and don't hesitate to contact us if you need any further assistance.
Best Regards,Dionathan Lopes[ALM Works]
Hi dionathan,
I do not see the sum values in my formula column. I want the sum of original estimates in formula. The sum needs to be in hours.
Thanks for letting me know.
In this case, you could try to add a column "Σ Original Estimate" and, for example, group issues by teams in your structure, and then the Original Estimate will be summed up for issues in each team-based group.
If you need further assistance with this, please reach out to us directly at support.almworks.com and we'll take a detailed look at your set-up.
Best Regards,Dionathan Lwww.almworks.com
Hey thanks for the post!
Do you know what the formula is for a column indicating the remaining issues' original estimates, basically subtracting the done issues' estimates from the total estimates?
It looks like you're new here. Sign in or register to get started.
