RYG Balls Default to Yellow if Due Date is Blank

Steve Bearden

Hello!

 

I have the RYG balls working great in conjunction with a "Complete" check mark and "Due Date" ranges.  However, I cannot seem to figure out how to apply the forumla to the entire column without seeing a bunch of default yellow balls if the row does not have a due date entered.  Is there a way to hide the balls all together until a due date is actually entered?

 

Current formula:

 

=IF(Complete2 <> 1, IF(TODAY() - [Due Date]2 > 0, "Red", IF(TODAY() - [Due Date]2 > -3, "Yellow", "Green")))

 

Thank you so much!

Christine Oakes

Hi Steve

 

I would start with =IF(ISBLANK([Due Date]2), "", and then the rest of your formula.

 

Christine