Child Auto Numbering per Parent Row


I am trying to find a way to auto generate sequential row IDs for the Child rows of each Parent row. We are doing a sheet per project, with all departments on the sheet, so ideally looking for a column that will auto generate a row ID based on the row position beneath the parent row.


CNC Item A1
CNC Item A2

Paint Item A
Paint Item B


I've done some searching but haven't found a solution that works for what I'm looking for. Any help would be appreciated.




  • Jake Gustafson
    Jake Gustafson ✭✭✭✭✭✭

    I'm intrigued by this. Not sure I have an answer, but what if you had an auto numbered column, then another column that used a formula to concatenate the work center to the unique identifier number. Assuming you've got that indicator (CNC, Fab, Weld, Paint, Assy) in another column. Maybe that'll get the creative juices flowing or someone else will swoop in with a solution.