AutoNumber Column help

System

This discussion was created from comments split from: Why isn't there a function to return the row number?.

Paul Newcome

How exactly is your Autonumber column populated? It looks like you have some duplicates in that column which will throw the row numbers off the way you are seeing. If you are using the system generated Auto-Number column, there shouldn't be any duplicates in it.

TJ North

I have implemented this formula using the auto-number column called 'AutoNumber.' For some reason, this is not returning the row number consistently. I cannot see any pattern to this - this sheet features parent/child relationships but the "out of order" rows are both parent and child rows. Does anyone have a suggestion for how to handle this?

Paul Newcome

How exactly is your Autonumber column populated? It looks like you have some duplicates in that column which will throw the row numbers off the way you are seeing. If you are using the system generated Auto-Number column, there shouldn't be any duplicates in it.

TJ North

Ah! Thank you for pointing that out! It is column type Auto number but yes, there are somehow duplicates. Thank you for catching that - I had assumed that was impossible. This is a plan that was created from one of our Control Center blueprints, so I will need to check that template out as well.

Paul Newcome

It is possible if rows were copied or moved in from another sheet. If there is no need for rows to be copied or moved in from another sheet, you will need to "reset" the auto-number column. Unfortunately this means breaking any formula that references it directly to include your row number formula. You will need to delete the column, save the sheet, add the column back, then fix any formulas that are now throwing the unparseable error.