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.

How to highlight a date in a column based off of another date

Erica Fresh
edited 12/09/19 in Archived 2017 Posts

Id like to highlight Column (Date Sent to Owner) in reference to Column (Due Date). 

If we hit the targeted Due Date, before or on the day that it is due- I would like Date sent to Owner to be highlighted green, if I we exceeded that date or it is past due, I would like that to be highlighted Red. 

Is this possible or is is wishful thinking? 

Thank you for the help. 


This discussion has been closed.