Annual Date Alert/Reminder

Hi. I have an employee data sheet with birth dates in one column. How can I set an annual alert that will remind me every year on the day and month their birthday falls?

As you can see above, currently at the end/beginning of every year, I search and replace the year in the Birthday column to the current/next year (now "2020") and the Alert is set to run every day and remind me at 7:00 am that it is an Employee's birthday.

Thank you

Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!