Employee Anniversaries

Steven Knight

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! 

Atus Bartal

Steven,

 

you can use the DATE() formula in another column (let's say "Anniversary") with the present year and the month and day of the entry date (column name "Entry"). The type of both column is Date.

It looks like this:

=DATE(YEAR(TODAY()), MONTH(Entry1), DAY(Entry1)) 

 

i hope it helps.

Atus

Atus Bartal

I forgot (but I guess you'll figure out): you can set a conditional formatting to "Anniversary" column