I am trying to make RYG circles correspond to a formula. My current formula, which has anything overdue marked red, anything due today marked yellow and anything not today is green works and is as such: =IF(Finish1 < TODAY(), "Red", IF(Finish1 = TODAY(), "Yellow", IF(Finish1 > TODAY(), "Green")))
I am trying to make it have anything today or overdue be Red, anything due in the upcoming 3 days be yellow and anything due further out than 3 days be green. This is what I have and it isn't working. I'd also like anything 100% complete or marked complete to have a blue checkmark.
=IF(Finish1 <= TODAY(), "Red", IF(Finish1 > TODAY(), "Yellow", IF(Finish1 > 3d(), "Green")))
Help Article Resources
Check out the Formula Handbook template!