Unique documentnumbers
Hi,
I would like to know if is possible to create unique documentnumbers based on input in coloumns. Or more important the opposite, prevent that a number is used twice.
E.g.: Metadata
Projectnumber will always be the same, drawingtype 1 will/might be different, drawingtype 2 will/might be different, area code will/might be different and so on. Within the different combinations of metadata I want to make sure that the serial number is not equal to serial numbers used before.
E.g.: Many 3D drawings will be generated through the project, many HP drawings will be generated through the project with same area code, same system, same originator. The only way to separate them from each other is the serial number.
Is it possible to generate unique numbers taking the above into account?
Best regards
Anne NO
Answers
-
Hi @Anne NO
I hope you're well and safe!
You could use the Auto-number feature, and then each Serial No would be unique and increase by one for each.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!