Auto numbering each line

Ivan Borisov

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. 

J. Craig Williams

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

Ivan Borisov

Thanks Craig, I'll keep in mind this information in my work.