IF or IF AND Formula conditions DATE

edited 12/09/19 in Formulas and Functions

Dear, I appreciate your help.

I need to create a formula that changes the status column depending on the following conditions. (The image in the example table has reference TODAY = August 28, 2019)

1) If the Balance column is equal to 0 (Green)

2) If the Balance column is less than 0 (Yellow)

3) If the Balance column is greater than 0 and the Expiration Date column is greater than TODAY (Red)

is possible?

(attached image)





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!