Using custom value for auto-number in primary field.
Scott S
✭✭
I read an old post that said use =[Row ID]1 to copy an automated sequence number in to the field specified. I want more that than just 1,2,3. I would prefer V00001, V00002 etc.. to increment for each new row. Is that possible?
Tags:
Answers
-
You could do:
="V" + [RowID]@row
This will give you V1, V2, V22, V100. If you want leading 0s you'll need to do a bunch of connected IF statements (I think) to check for how big the number is. An example of the start of that formula would be:
=IF([RowID]@row < 10, "V0000" + [RowID]@row, IF([RowID]@row < 100, "V000" + [RowID]@row))
etc, etc
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!