Indentation

Desertbird · 08/19/21

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 · 08/19/21

Are you able to provide a screenshot for refrence?

Desertbird · 08/19/21

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 · 08/19/21

Where are you wanting to put this count?

Desertbird · 08/19/21

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

Desertbird · 08/19/21

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 · 08/19/21

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 · 08/20/21

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")

Indentation

Answers

Help Article Resources

Categories