Reset Auto numbering using Automation

I'm using a form to captur data in a smartsheet and I need the auto numbering to reset annually. Deleting the column manually isn't an option since I can't delete the data in the current sheet and also the column is used in equiations in other columns.

Any advice?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!