I'm trying to set up a formula to calculate a Reminder status by days. I have a deadline date that is in the past, but it does not turn my status column to a "Red" dot, it remains green and I do not know how to add to this formula to make that happen.
Here's the formula I have in place, and it works, but I need status to change to "Red" dot if my deadline date is past due. Can you help?
=IF([Sponsorship Status Complete?]@row <> 1, IF([(HIDE) Sponsorship Info Status Reminder]@row < 1, "Green", IF([(HIDE) Sponsorship Info Status Reminder]@row <= 30, "Red", IF([(HIDE) Sponsorship Info Status Reminder]@row > 30, "Yellow"))))
Help Article Resources
Check out the Formula Handbook template!