Send reminder/update a date to be the same date the next year

We are trying to create a sheet that tracks various dates an automated reminder should be sent on an annual basis for each of our properties. The date will vary across properties, and the reminder should be sent on the same day every year.

For example, Property A has an annual sprinkler reminder date of 8/1, and Property B has an annual sprinkler reminder date of 10/5. Every year on 8/1 we want an automated notification to go to a distribution list for Property A, and every year on 10/5 we want an automated notification to go to a distribution list for Property B.

Our preference is to avoid having to manually reset the year to the next year each time it is sent, but I can't figure out how to track just a month and date without a year, or to track a full date with a year and have that date set itself to the next year automatically once that date passes.

Any ideas?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!