IF AND Formulas for Flagging

Angelique H.

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!

David Tutwiler

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)

Angelique H.

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 %

David Tutwiler

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)

Angelique H.

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

Devin Lee

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))