Formula to change symbols

EmilyRamirez

Can someone please help me with a formula? I want to automate the yellow ball two days before the due date and the red ball the day after the due date when the "Done" column is not checked.

Thank you for your help!

Kerry St. Thomas

=IF(AND(Done@row=0,[Due Date]@row<TODAY()),"Red",IF([Due Date]@row<= TODAY(2), "Yellow",""))

I prefer to start with "Worst Case Scenario" then work my way up: If you tried to start with the YELLOW color, it would turn Yellow two days after the due date passed again.

Good luck~

EmilyRamirez

Thanks Kerry, this almost got it. The yellow shows up at the accurate time. But the red does not. It also needs to take into consideration the check box. If the box is checked in the Done column, I would like the At Risk column to either be blank or have the green ball. I'm fine with either.