How do I adjust formula to exclude Status Complete

Options
NMillerTX
NMillerTX
edited 06/21/22 in Formulas and Functions

I am completely new to making formulas in Smartsheet. I searched the flag formulas in the forum and found this one to do what I need to do, except I need it to exclude flagging Status = Complete. I'm not sure how to adjust to omit.

Thanks in advance! I will start reading up on how to create formulas.


Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓
    Options

    Hey @NMillerTX

    Because a 'Complete' status trumps any condition, my preference is to separate it from other conditions and have it stand alone. Formulas execute from left to right until the first True condition is encountered, then the formula stops. Because we want the formula to stop when a Complete is reached, we will place that condition first in the IF statement.

    =IF(Status@row="Complete", 0, IF(AND([End Date]@row<=TODAY(7), [End Date]@row>=TODAY()),1))

    Kelly

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!