Countifs Parent rown

Karrie Davis
Karrie Davis Overachievers Alumni

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

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!