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!
Answers

I think you just have your arguments wrong. If you need both criteria to be true (AND) then it should look like this:
=IF(AND([Risk Score]@row > 0.5, COUNTIF(CHILDREN(), true) > 0), true)

Hmm, I am not sure that is what I need because the Leadership Flag row should flag if any "High" risk questions (under Leadership) are flagged and right now it's still basing off the %

I see, I just didn't add the High Risk scores in there. Maybe this then?
=IF(AND([Risk Score]@row > 0.5, COUNTIF(CHILDREN(), true) > 0), COUNTIF(CHILDREN([Risk Priority]@row), "High") > 0), true)

Still returned #Unparseable :(  not sure if has to do with the Children() does that need to be Flag@row?

Hey @Angelique H.
Give this formula a go.
=IF([Risk Score]@row >= 0.5, 1, IF(COUNTIFS(CHILDREN([Risk Priority]@row), "High", CHILDREN(Flag@row), 1) > 0, 1, 0))
Help Article Resources
Categories
Check out the Formula Handbook template!