Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

RYG Balls Default to Yellow if Due Date is Blank

Steve Bearden
edited 12/09/19 in Archived 2015 Posts



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!



This discussion has been closed.