Can I have an auto number created for parent columns only?

jamesparker

Hello,

I would like to have an auto-number created in a column called FO Number, however I only want the number created in parent rows, not their children.

The number also has to line up with a separate database I use and therefor needs to start at 1886 for the first job in my sheet.

eg. VS-CL01GP407-B will have FO number 1886 with all its children blank and Part B - Plate will have FO number 1887.

Is this possible

Screenshot 2024-04-08 074959.png

Paul Newcome

My suggestion would be to enter an auto-number column (called "Auto" in this example) and then a text/number column (called "Row" in this example) with the following column formula:

=MATCH(Auto@row, Auto:Auto, 0)

Then in a text/number column you can use this to get your sequential numbering on your parent rows:

=IF(COUNT(CHILDREN([Fab Database Number]@row))> 0, COUNTIFS(Customer:Customer, @cell <> "", Row:Row, @cell< Row@row) + 1886)