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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!