Calculation with multiple conditions - if statement?

Options

I'm calculating the number of days between my due date and today. I'm trying to make this calculation based on a separate column NOT being certain conditions. I have successfully done the following:

=IF(Stage@row <> "9 Released", [Due Date-Plan]@row - TODAY())

But I want this calculation to also exclude those items in the Stage column that are "X On Hold" and "Z Rejected".

I've tried below, which doesn't work.

=IFs(Stage@row <> "9 Released", Stage@row <> "X On Hold", Stage@row <> "Z Rejected", [Due Date-Plan]@row - TODAY())

Suggestions?

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Angie Little ,

    Try:

    =IF(AND(Stage@row <> "9 Released", Stage@row <> "X On Hold", Stage@row <> "Z Rejected"), [Due Date-Plan]@row - TODAY(),"")

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!