Auto numbering each line

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