How Can I set up RYG Using Future Dates?

Daniel Crippen
edited 03/11/21 in Formulas and Functions

Hi There,

I am trying to set up a formula that follows this logic:

-If Approval Date is xx and today is before that = that day it should be Green

-If Approval Date is xx and after that date = Red

-If Approval date is xx and the day of = Yellow

I'm trying something like this: =I=IF([Approval Date]@row > TODAY(), "Green", IF([Approval Date]@row) < TODAY(), "Red", IF([Approval Date]@row = TODAY(), "Yellow")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!