Yeah, the problem here (as you mentioned) is that the auto numbering can’t be set or reset.

Here’s a clunky (but simple) workaround for this:

If you know what the highest Autonumber is for this year (at the end of the year), then next year, you can just subtract that number from next year’s formula to “fake reset” the number for next year.

So it’s sort of a “fake reset” every year. You would be required to manually update your formula once per year. Your formula would subtract a different number each year (based on the year), and those numbers would be hard-coded by you into your formula.

So, in plain English. your formula‘a logic would be something like this:

if this record’s year is 2020, just use the normal autonumber.

If this record’s year is 2021, then subtract X from the autonumber.

If this record’s year is 2022, then subtract Y from the autonumber.

And so on. You would manually update the formula once per year.

I’m sure that someone will be able to come up with a more automated trick involving linking tables & rollups & lookups, but this was just an easy solution that popped into my head.