RYG Ball Automation
I am trying to automate the 'Health' column on a sheet. I have it set up to turn RYG when a certain status is selected but I would also like it to turn Red if the Due Date or Due for Review is a past date and the status is still listed as anything but 'Complete."
I currently have this formula in place
=IF(Status13 = "Not Started", "Red", IF(Status13 = "In Progress", "Yellow", IF(Status13 = "Complete", "Green", IF(Status13 = "Needs Edits", "Yellow", IF(Status13 = "Waiting For Review", "Yellow")))))
How would I add to it to make the date being in the past trigger a Red ball in the health column with the rest of the formula as well?
Help Article Resources
Check out the Formula Handbook template!