# IF AND Formulas for Flagging

Options
✭✭✭

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!

Tags:

• Overachievers Alumni
Options

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)

• ✭✭✭
Options

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 %

• Overachievers Alumni
Options

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)

• ✭✭✭
Options

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

• ✭✭✭✭✭
Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!