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.

Employee Anniversaries

Steven Knight
edited 12/09/19 in Archived 2016 Posts

We use Smartsheet for a number of different departments, HR being one of them. I'm wondering if there's a way to conditionally format a "hire date" cell to change colour when an employee anniversary is approaching? There is currently an option to conditionally format for a date that is a certian amount of days in the future, however because the "hire date" is posted in a previous year this option does not work. 


Thanks for your help! 


This discussion has been closed.