Child Auto Numbering per Parent Row

lwells

Help!

I was wondering if anyone could help me. I am so thankful for Brian Richardson original post from 07/2024 showing the breakdown, I think it is the answer that I have been looking for. But I can't get the formula to work. Can you help me?

Columns:

Parent Formula I have:

Child Number Formula I have: I think it is this formula that is throwing the NO Match for both Child # and Child Ref.

Child Reference Formula I have:

End result:

The report was created prior to using Parent/Child rows, and I am going back and adding the child rows but I need them to have the same DA | Closing ID # ( I will hide all the Auto - Child Ref Col), and I would like the Child # to be CRG | DA - 1004.1, 1004.2, 1004.3 etc.

I appreciate any help you can provide. Thank you in advance

Lisa Wells

David Tutwiler

Tagging @Brian_Richardson

Paul Newcome

Once you get the formula in the [PARENT] column, you should be able to skip over the helper columns that come after and just use something along the lines of

=IF(COUNT(ANCESTORS([DA | Closing ID]@row)) > 0, [DA | Closing ID]@row + "." + COUNTIFS([DA | Closing ID]:[DA | Closing ID], @cell = [DA | Closing ID]@row, [Row Number]:[Row Number], @cell <= [Row Number]@row))