Calculation with multiple conditions - if statement?

✭✭✭

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

• ✭✭✭✭✭✭
Answer ✓

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

• ✭✭✭✭✭✭
Answer ✓

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.

• ✭✭✭

Thanks! That worked!

• ✭✭✭✭✭✭

Excellent. Glad you found a solution. Thank you for contributing to the community. Mark

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!