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

[Jessica Wang]

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?

[Stepan Kholodov _Tempo_]

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,
Stepan
Tempo (the Structure app vendor)

[Jessica Wang]

Thank you very much!