Countifs Parent rown

Karrie Davis

I have a countifs formula

=COUNTIFS({DO VSD Workstream Action Plan Range 4}, $WorkStream@row, {DO VSD Workstream Action Plan Range 1}, "Complete", {DO VSD Workstream Action Plan Range 2}, 0)

But in front of the first criteria I only want to count the rows with same parent row

I've tried =COUNTIFS(Parent({DO VSD Workstream Action Plan Range 4}, $WorkStream@row), {DO VSD Workstream Action Plan Range 1}, "Complete", {DO VSD Workstream Action Plan Range 2}, 0)

I get an incorrect Argument set

Genevieve P.

Hi @Karrie Davis

Cross-sheet formulas can't identify hierarchy so you would need to have the Parent name next to the Child details for it to pick up this value.

Do you have the Parent Title populated down each of the Child Rows as well? For example, in a Helper Column with the formula:

=PARENT([Primary Column]@row)

If so, you can add another {Range} and "Criteria" looking for that specific parent, something like this:

=COUNTIFS({DO VSD Workstream Action Plan Range 4}, $WorkStream@row, {DO VSD Workstream Action Plan Range 1}, "Complete", {DO VSD Workstream Action Plan Range 2}, 0, {DO VSD Workstream Column with Parent}, "Parent Name")

or

=COUNTIFS({DO VSD Workstream Action Plan Range 4}, $WorkStream@row, {DO VSD Workstream Action Plan Range 1}, "Complete", {DO VSD Workstream Action Plan Range 2}, 0, {DO VSD Workstream Column with Parent}, [Parent Name]@row)

Let me know if this makes sense or if I can clarify further.

Cheers,

Genevieve