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

Jessica Wang_34hjt7

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

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)