Creating Helper Column to Set a Date to reoccur annually

I am working on a project that tracks quarterly and annual filings. The date will vary depending upon the type of filing. I want to set it up so that reminders are sent automatically without a specific year in place. For example, a corporate annual report reminder date should be 6/30. Every year on 6/30, we want an automated notification to go to a designated person to file this annual report.

We are trying to avoid having to manually reset the year to the next year each time. I have been reading on the community site that helper columns can be set up to achieve this. However, I can't figure out how they work or how to set them up.

Any help is very much appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!