Generate Unique Numbers
Answers
-
Hello
i have an excel sheet that is connected to a form I want to generate numbers From 001... How do I automatically number an item according to its kind in Microsoft excel eg. 001 will start the numbering of an item and another item will be also start from 001 eg. in (form) i have a drop down menu of different choices i want to give each choices its own sequential numbering so it means if i have camera, projector mobile phone on my dropdown list..
it will be counting by the next entry
camera-001
projector -001
camera-002
mobilephone-001
camera-003
projector002
-
If it didn't matter if the numbering was sequential you could have the autonumber column as created by smartsheet & Join formula with the column for the type of equipment.
Camera-001
Projector-002
Camera-003
=Join(Number@row +","+[Equipment type]@row+)
if you need the numbers to be sequential according to their equipment type, then the formula gets a little trickier and you are working with if & countif formulas and embedded statements for adding the 00 in front of your number. IF this is the path you want to go by, you will want to build the formula one step at a time and add the embedded statements as each formula works properly. I would hate for you to create something long and complicated for it to error out and you don't know where it went "wrong".
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!