Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Auto numbering each line
1. Is it possible to assign the values of the number in each new line with a given step (or digit number) For example:
005
010
015
020
025
etc.
2. If I need to insert a new line between 010 and 015, I would like to be able to recalculate all subsequent rows in accordance with clause 1. And the second option is to set the new line to 011 or 012: for example:
It was
005
010
015
020
Became:
005
010
011
015
020
add one more line:
005
010
011
012
015
020
At the moment I do it manually but when you have more than 200th line it became harder and harder))
It would be nice to take some advice from guru of smarsheet.
Thanks.
Comments
-
Ivan,
1. No, Smartsheet's Auto-Number increment is 1 and can not be changed.
2. No, that's not the way Auto-Number works - (in Smartsheet or others that I am aware). When a new row is added, that row gets the next number (incremented by 1 for Smartsheet), regardless of where it is in the sheet/table.
If you were only looking for increments by 5, then this is what I would do:
1. Create a new column (Text/Number). For example, [Row Count]
2. Create a formula in row 2 that is
=[Row Count]1 + 5
3. And then copy that down to the rest of the [Row Count] column.
The problem with this method is that if you add, move, or delete rows, the numbering can get screwed up (quite easily.). To resolve this (it will be obvious either with the #UNPARSEABLE or #BLOCKED error in one or more cells), just repeat step 3 again (assuming row 1 and 2 were not affected by the move/deletion)
However, adding the "not incremented by 5 too" requirement, throws that out the window as there won't be any way for the system to know about which 'group of 5' it resides.
If there is something else in the Sheet that could tell the system that the new row is 25 and not 21, then there still may be hope, but I can only speculate about it at this point.
Craig
-
Thanks Craig, I'll keep in mind this information in my work.
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