two factor RGB balls formula. Status and Date
I know this has been asked a million times and I have looked at all the other post, but still cant get it to work.
Status options are:
Transferred To Other Department
Due date is standard date format
I am trying this as the formula:
=IF(Status@row = "Transferred To Other Department", "Green", IF(Status@row = "Complete", "Green", IF([Response/ Resolution Deadline]@row - TODAY() < 0, "Red", IF([Response/ Resolution Deadline]@row - TODAY() <= +5, "Yellow", "Green",))))
I know I am just missing something but I cant figure it out.
Help Article Resources
Check out the Formula Handbook template!