Countifs Parent rown

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
-
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!