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:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!