Auto number column gets messed up

Amit Wadhwani
Amit Wadhwani ✭✭✭✭✭✭


I'm using auto number column property to have the number assigned automatically to each row. Everything works fine if updating the sheet line by line.

But once I insert a row in between

Now i add values and hit save.

the auto number system forgets the upper and lower row numbers and starts the value from the very last row.

This is really make or break for me, I've other sheets with 2000+ lines of data and I can't always reset the column values.

Best Regards

Amit Wadhwani, Smartsheet Community Champion

Smartsheet CoE, Ignatiuz Software, Exton, PA

Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"