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