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



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


  • Paul Newcome
    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)