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

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

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!

Tags:

Comments

This discussion has been closed.