Can the autonumbering function be set up to utilize new numbering prefix at start of each year?
I created a sheet that uses autonumbering to assign a number to all submitted forms. I want the numbering to utilize a prefix denoting the year and start over at 0 each year. For example the numbering of the submissions in year 2021 will start with 202101 continuing with 202102, 202103, etc. When the year 2022 is reached, I would like any new requests to use a 2022 prefix (e.g. 202201, 202202,...). Is there a way to set this up?
Answers

The autonumber feature can't do that, but you could use a formula.
Insert a column to track the submitted date (Created Date column) and then in a text/number column use something like this...
=YEAR(Created@row) + "" + COUNTIFS(Created:Created, AND(@cell <= Created@row, IFERROR(YEAR(@cell), 0) = YEAR(Created@row)))

Thanks for the formula for this! I was able to restart numbering for each year based on 'create' field. I have 2 followup questions:
 The formula works if you don't have mulitple items that show created at same date/time  because of the 'countifs' formula, it does not count it as unique  anyway to adjust the formula to avoid this?
 How do i format the result to be 2024001 vs. 20241 so that when it's sorted, the numbers fall in line?
Thanks!

@joseply_68 You can insert an autonumber column that has no special formatting and leverage that. A RIGHT function will take care of the zerofilling.
=YEAR(Created@row) + "" + RIGHT("000" + COUNTIFS(Created:Created, IFERROR(YEAR(@cell), 0) = YEAR(Created@row), [AutoNumber]:[AutoNumber], @cell<= [AutoNumber]@row), 3)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!