Indentation

Desertbird

Hello,

I'm having trouble putting together data that has been indented. The parent row is the start date, and the indented information is tracking recruits and offers. How do I combine a countifs function that is strictly focused on a single set of indented data, such as how many recruits will start on 8/16/2021?

Paul Newcome

Are you able to provide a screenshot for refrence?

Desertbird

I cannot share the sheet due to personal information, but this is basically what I mean, where the rows can be expanded or collapsed. If the names are sharing the same column as the parent row (date), how do I pull the number of "completes" per date? There is no additional column with the start date and we cannot add one at this time.

Paul Newcome

Where are you wanting to put this count?

Desertbird

It would be stored on a separate sheet that has other metrics we monitor. It would only take up a single cell.

Desertbird

From what I've found this is what I have been able to come up with

(the -4 is because it is 4 days until the next hire date, but that will be removed once it is live).

Error: Unparseable

=COUNTIFs(Children({New Hires PHX3 Range 1}@row),TODAY(-4),Children({New Hires PHX3 Range 2}@row),"Complete")

Desertbird

I also tried with just a countif function: =COUNTIF(CHILDREN(Today(-4)){New Hires PHX3 Range 2},"Complete")

Same error though, any ideas?

Paul Newcome

You are going to need to insert a helper column (which can later be hidden to keep the sheet looking clean) that pulls the parent value into each of the child rows.

=IF(COUNT(CHILDREN([Primary Column]@row) = 0, PARENT([Primary Column]@row)

Then in your metrics sheet you would have

=COUNTIFS({Working Sheet Helper Column}, @cell = "8/16/2021")