Auto number column gets messed up

Amit Wadhwani

Hello,

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.

Amit Wadhwani

FYI - I'm using the RowID in the formulas, so I need this to accurately point to the correct row.

Andrée Starå

Hi Amit,

Unfortunately, that is by design. We could probably create a formula structure, so you'll have row numbers instead.

Would that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Amit Wadhwani

Hi Andrée,

That would be great, but would that formula still work when adding rows in between?

Andrée Starå

Yes, as long as the formula structure is intact it will work.

✅Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Amit Wadhwani

Tried it, but the formula doesn't gets copied to the new row inserted. See screenshots.

This is the formula I used, now when I insert a row anywhere between and when I type something in primary column and hit save then the formula doesn't gets copied.

Amit Wadhwani

@Andrée Starå Any luck with the formula? I'm still stuck with this and formula just doesn't gets copied to the newly inserted row.