Trouble with Auto Number column type. Shows up different in cell.


I am trying to use the auto number system and am having a little trouble.

You can see in the first image that I have programed it and the preview is pictured as well. First cell should populate as C001.

From the second image, you can see how it populates in the cell. It is stating with the number C011 instead.

Can anyone explain to me what is happening and how this auto number concept works.

Thanks in advance.


  • Toufong Vang
    Toufong Vang ✭✭✭✭✭

    The auto-number counter begins at the time that the column is created. It's likely that 10 rows had been created and deleted between the column's creation time and the time that it was reconfigured.

    To renumber the rows without deleting the column:

    1. Change the column to a Text/Number column type.
    2. Delete the values in that column and save the sheet.
    3. Refresh\reload your browser page.
    4. Change the column to an Auto number column type, configuring it as needed, and save the sheet.

    Step #3 is key.