Auto Flag a row for Multiple Conditions

Options

Hi,

I need to auto flag a row if any of the dropdown in the RAIDD column is selected. (extra D is for Decision)

=IF(RAIDD@row = "Risk", 1, 0)

This formulae works and flag the row. However, how do I get others added like Assumption, Issue, Dependency, Decision

=IF(RAIDD@row = "Risk", "Dependency","Issue" 1, 0).......This isnt working

Please help

Best Answer

  • Josh G
    Josh G ✭✭✭
    Answer ✓
    Options

    You could do a nested IF statement. For example:

    =IF(RAIDD@row = "Risk",1,IF(RAIDD@row = "Assumption",1,IF(RAIDD@row = "Issue",1,IF(RAIDD@row = "Dependency",1,IF(RAIDD@row = "Decision",1,0)))))

    Alternatively, search for a blank value and finding anything else, assume true. For example:

    =IF(RAIDD@row="",0,1)

Answers

  • Josh G
    Josh G ✭✭✭
    Answer ✓
    Options

    You could do a nested IF statement. For example:

    =IF(RAIDD@row = "Risk",1,IF(RAIDD@row = "Assumption",1,IF(RAIDD@row = "Issue",1,IF(RAIDD@row = "Dependency",1,IF(RAIDD@row = "Decision",1,0)))))

    Alternatively, search for a blank value and finding anything else, assume true. For example:

    =IF(RAIDD@row="",0,1)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!