Auto-assign sequenced number to new project(s) sheet
Is there a way to automatically assign a uniquely sequenced ID# to each newly created project sheet?
We'd like to do this for/across a group of users that collaborates on short-termed projects (3-6 mos). Basically have the application assign a unique and automatically sequenced ID# for each new project.
Thanks in advance.
Comments
-
Hello Carole,
There currently isn't a way to auto-assign an ID on the sheet level, but you can do this on the row level with an auto-number system column. You might consider having a sheet that has all of your projects as single rows or line items. The auto-number column will generate a unique ID, then you can copy and paste that into your individual project sheets as needed. More info on system columns here: https://help.smartsheet.com/articles/1964567-system-columns
-
Shaine,
thank you very much for your reply. we'll look in to this and give it a try.
Carole
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives