IF AND Formulas for Flagging
Hi again, I am trying to have flag a parent row based on 2 separate criteria: 1) if the overall risk score is <50% and 2) if any Children rows have any High Risk questions Flagged
I have tried it a couple of ways still receiving #IncorrectArgument and #Unparseable
Below is #IncorrectArgument
For #Unparseable: =IF([Risk Score]3 > 0.5, 1, IF(AND(CHILDREN([Risk Priority]@row="High", Flag@row = 1, 1)))
Appreciate any help!
Help Article Resources
Check out the Formula Handbook template!