Structure Formamula Syntax for Conditional Progress Column

Question

Hello All!

I am looking to write a formula to calculate % complete based on the following conditions.

I have tried to write it myself as well as use Chat GPT and we haven’t been able to get anything to take, constantly getting syntax errors.

It’s a bit complicated, hoping someone can help me.

In English, this is what I’m looking to do

* If resolution date IS NOT EMPTY : 100%* else* If original estimate IS NOT EMPTY and remaining estimate IS NOT EMPTY : remaining estimate/ original estimate (show as a %)

* else* if original estimate OR remaining estimate is EMPTY : “Unable to calculate”

Alexandria (Lexi) Codd · Answer

thanks! I just got back from being away, tried that and it was really helpful.

is there any way for the formulas to properly consider the subitems?

Example: I'd like the parent levels to collect the sums the child items and provide the collective percentage at my epic level. Selecting "sum over subitems" doesn't seem to do this. I expected to see it in the space highlighted in the yellow box next to the calculated value for the row:

Stepan Kholodov · Answer

Hello @Alexandria (Lexi) Codd

You can try something like this:

if resolution: concat(100,"%") else
if originalestimate and remainingestimate: concat(remainingestimate/originalestimate*100,"%") else
"Unable to calculate"

The formula will first process all issues that have a resolution. Then it will process issues that have both original & Remaining Estimate in them; and it will return the 'Unable to calculate' for all issues that don't have either or both in them.

I hope this helps. If you have more questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)