Structure formula

Amzad Khan_xg23n0

I am trying to build a structure in which I want to add a column called Error with Yes and No.

Can anyone help to add a formula for that where I want to get Yes in the column whenever Parent is in status category done and child is not in status category.  In the below screenshot OQS is the parent and OQT is the child issues.  Can any please provide the formula for the same.

 

Stepan Kholodov

Hello @Amzad Khan 

You can do it with a formula like this:

if parent{statuscategory} = "done" and statuscategory != "done" : "YES"

The formula checks the Status Category of the parent issue and compares it to the issue's own Status Category, and returns 'Yes' if they don't match.

I hope this helps. If you need further assistance, please reach out to us directly at our support portal, and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)