Structure, how to check in a formula if all children is status done ?

[Joakim Wöntner]

Hey guys i am trying to write an estimation check that checks if the epics estimation is the same as the sum of the childrens. if that is NOT the case i do a red circle. 

But there is some conditions im trying to wrangle. 

- if status of epic is done exclude the item
- if status of all children is done exclude the item 

this is how far i got

IF type = "epic" AND
originalestimate != SUM#children{originalestimate}: ":red_circle:"

[David Niro · Accepted solution]

Hello @Joakim Wöntner ,

Please give this a try:

with _childstatus = VALUES#children{status}:

IF issuetype = "EPIC" AND status != "DONE" AND _childstatus != "DONE"
    AND originalestimate != SUM#children{originalestimate}:
        ":red_circle:"

the with _childstatus is a variable that takes into consideration the status of each Epic's children.  If ALL of them are "DONE" then the array that VALUES{} returns will only "DONE", which makes it = to.  Any additional statuses will make it != to.  We then add it as a condition to your IF statement.

The rest of it is your exact formula.

Please let me know if this helps!

Best,
David