How Can I set up RYG Using Future Dates?

Daniel Crippen

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")

Erika Sajdak

Something like this?

=IF([Approval Date]@row > TODAY(), "Green", IF([Approval Date]@row < TODAY(), "Red", IF([Approval Date]@row = TODAY(), "Yellow")))

Erika Sajdak

Something like this?

=IF([Approval Date]@row > TODAY(), "Green", IF([Approval Date]@row < TODAY(), "Red", IF([Approval Date]@row = TODAY(), "Yellow")))