Mimic a Pivot Table, Group by date and SUM

It's the Row@row for the IF statement being true that is doing it. It's just taking the value for the ROW column when the IF statement is true rather than incrementing the counting from 1 : N

Thanks a lot for your help, seems to be working now. I'll just need to wrap some IF statements around the Row ID and Row columns in the pivot so they don't show Invalid Value errors. For completeness if someone else ever sees this, this is what I have in the Pivot sheet

Row ID column with sequence of numbers 1:N

Row column with

=SMALL({Data Sheet Rank Column}, [Row ID]@row)

Dates Column with

=INDEX({Data Sheet DateNumber Column}, MATCH(Row@row, {Data Sheet Rank Column}, 0))

Thanks for the tip, definitely made it easier.

Of course it then made all the values in the dates column of the pivot table sheet with blank ranks all be the same date. This one I wrapped in an IF looking for ISBLANK in the rank column.

So, ran into a new problem now that I have the SUMIFS in the pivot table. I have some rows that are Parents that sum from children. So now my SUMIFS also sum those parents because they have the matching date in them. Is there a way to skip those Parent rows, or do I need another helper column that has only the dates from the rows I'm interested in summing.

I'm guessing the latter?

I found your suggestion on another post but between sheets I'm not seeing how to implement it.

=IF(COUNT(CHILDREN()) = 0, original_formula)