If/And Statement

Hey again,


I am stuck with something a bit beyond my current skills.

I need to write a formula that I believe will be an If/And Formula.

The formula needs to populate the Case Status cell.

If the the Tentative Return Date column is blank, the Case Status Cell should be "N/A", if the Tentative Return Date is within 10 Days Case Status should be "Active Case" and if Tentative Return Date has more than 10 days passed since the submission it should read "Past 10 Days."


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!