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

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
    Atus Bartal ✭✭✭✭✭



    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 Bartal
    Atus Bartal ✭✭✭✭✭

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

This discussion has been closed.