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
- Customer Resources
- 67.1K Get Help
- 450 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
