Row numbers

veronica.cortes55311

no such luck!

Darla Brown

@Paul Newcome Oh great and wise one I have a question regarding this topic.

I've already used the auto-number column for a prepaid invoice. Now I need to auto-number final invoice. My original helper column was to start at row 1 with a baseline and the use a formula to reference cell above and add 1. That worked perfectly until they automated the rows to move to the archive sheet. :( So now I need a permanent solution to keep running numbers even if the row moves. Any ideas?

Paul Newcome

@Darla Brown What formula are you currently using?

Darla Brown

=helper1+1

But I've decided to go a different route because we couldn't make this work as a formula column. And I needed to remove anything manual.

Instead, I'm using the Group ID (which is a unique ID) to join with a suffix we use as an identifier. =JOIN([PMS ID/Group Code]@row + "GCF") I can make this a formula column and moving the row won't break anything. :)