How to use structure's column to calculate remaining original estimates for incomplete issues

Jessica Wang May 17, 2024

Hey Jira Community!


Does anyone know how to use the formula in Structure to calculate the sum of "original estimates" of any incomplete tasks? For example, If an epic has 2 tasks, and each task takes 1 day, then the total original estimate for the epic is 2. But if 1 task is done already, the remaining estimate for the epic should be 1. Anyone knows how to do this?

1 answer

0 votes
Stepan Kholodov _Tempo_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 22, 2024

Hello @Jessica Wang 

I'll repeat the answer that I posted to you in another post, just in case anyone else finds it here. You can do it with a formula like this:

sum{originalestimate} - sum{if status = "done": originalestimate}

Please reach out to us directly at our support portal if you need our help with anything.

Best regards,
Tempo (the Structure app vendor)

Jessica Wang May 24, 2024

Thank you very much! 

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events