Changing column Property Status (Red, Yellow, Green) when two columns dates are different

Roberto Sanchez
Roberto Sanchez ✭✭✭
edited 12/09/19 in Formulas and Functions

I am in need for the status colum 1 (red, yellow, green) to automatically change when column 2 (date) is passed column 3 (date). Can this be done with a formula? 

I can do "=IF([Approved Required Delivered Date]1 < [Adjusted Delivery Date]1, "Red")", however, I am sure on how to add the other two conditions in the formula.

Thank you,

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!