Autonumbering of Multiple Categories

Hi,
I am building a centralised event capturing (by form) register which may contain 5 - 6 different types of events (incidents, actions, improvements etc.).
I want to have a number automatically assigned that is sequential, based on the previous number of the same category. Example below.
I have played around with a few options but cannot get it to work.
New entries can be added to the top or bottom of the sheet, although top is preferred but not essential (since the output will be reviewed by reports most likely).
Best Answer
-
Insert an auto-number column (called "Auto" in this example) with no special formatting and then use the below column formula:
=UPPER(LEFT([Type of thing]@row, 3)) + "-" + COUNTIFS([Type of thing]:[Type of thing], @cell = [Type of thing]@row, Auto:Auto, @cell<= Auto@row)
Answers
-
Insert an auto-number column (called "Auto" in this example) with no special formatting and then use the below column formula:
=UPPER(LEFT([Type of thing]@row, 3)) + "-" + COUNTIFS([Type of thing]:[Type of thing], @cell = [Type of thing]@row, Auto:Auto, @cell<= Auto@row)
-
Thanks @Paul Newcome. Worked straight out of the box. Much appreciated.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 73 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!