Adding another condition to an IF AND Statement

This discussion was created from comments split from: Formula for IF cell is NOT BLANK and value < 'x".

Comments

  • JPUMBARGER
    JPUMBARGER ✭✭✭✭

    I have a similar issue. I have the following formula to set an "At Risk Flag":

    =IF(AND(Status@row <> "Completed", [% Tasks Progress (Manual Entry)]@row < [Time Track % Complete for at risk]@row), 1, 0)

    Here is what I want to add:

    If the "Duration" cell in the row is Blank, I do not want it to set a flag. I have tried to get it to work but no success yet.

  • Genevieve P.
    Genevieve P. Employee Admin

    Hey @JPUMBARGER

    Following-up as I found your comment on an older thread and want to ensure you received a response. You can add another condition to your same AND statement that says that in order to return 1, the Duration cell is not blank:

    =IF(AND(Status@row <> "Completed", [% Tasks Progress (Manual Entry)]@row < [Time Track % Complete for at risk]@row, Duration@row <> ""), 1, 0)

    This means that if it IS blank, it won't meet all the criteria so the IF statement will return 0.

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!