Child Auto Numbering per Parent Row

lwells

Help! In a Time Crunch!

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

Corey W.

There is an issue in the green portion of the child number formula. For the range you are collecting, you will want to remove both @row statements.

lwells

Corey,

Thank you for responding, I appreciate it.

I was following the below instructions:

On Step 4: you are saying to remove the "@row" statements, which ones?

lwells

Corey,

Thank you for responding, I appreciate it.

So I was following the below instructions from Brian Richardson:

On Step 4: Which "@row" statements are you stating to remove?

Corey W.

@Iwells, The ones in your COLLECT function in green. This part of the function should be a range of cells so you shouldn't have the @row portion. Make yours match step 4 in your screenshot.