Unique Row Identifier For a Workspace
Hello,
I need to have a column for all sheets in a Workspace which has a unique ID for each row. I know that I can use the system generated auto-number for the column however I need to ensure that the ID in the cell is unique for all sheets in the given Workspace. Any suggestions?
Answers
-
Hi @IKatz101 ,
You could set up the prefix and suffix of the auto-number to be unique for each sheet. Would that accomplish what you are looking for?
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
-
Thanks for commenting. This is one solution however I was hoping there would be a solution which is less of a manual process.
-
It may be possible to set the auto-number prefix/suffix using the API. http://smartsheet-platform.github.io/smartsheet-csharp-sdk/html/6c604023-fc93-fa83-2132-6f28a625c094.htm
However, beyond that the most "automated" way would be to set the prefix and/or suffix for each sheet.
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives