Count Children Rows w/ Specific Statuses
Hello,
I have a Status column that has the following drop-down items - To Do, In Progress, Done, and Future Work Cycle Task. I want to sum the # of child rows with the status of To Do or In Progress.
I tried =COUNTIFS(CHILDREN(), "To Do", CHILDREN(), "In Progress") and it doesn't work; however, when tried just =COUNTIFS(CHILDREN(), "To Do") it worked and tried =COUNTIFS(CHILDREN(), "In Progress") it worked. I just need these numbers to add together :(
Best Answer
-
Try this instead:
=COUNTIFS(CHILDREN(), OR(@cell = "To Do", @cell = "In Progress"))
Answers
-
Try this instead:
=COUNTIFS(CHILDREN(), OR(@cell = "To Do", @cell = "In Progress"))
-
THANK YOU SO MUCH! It works. I really appreciate it.
-
Happy to help. 👍️
-
This formula has helped me with what I am working on so thanks for asking & thanks for responding!
I am trying to use a similar formula but I am looking for it to count in the parent row where multiple drop-down options can be selected in the same cell of the child row. Here is the formula I am using now:
=COUNTIFS(CHILDREN(), OR(@cell = "Line of Business 1", @cell = "Line of Business 2", @cell = "Line of Business 3", @cell = "Line of Business 4"))
This works great if only one of the drop-down options (found in the quotation marks) is selected however, if more than one responses are used it doesn't count that cell.
How can I amend the formula so that the cell is still counted if it contains either one of the drop-down options or if it contains more than one? (I hope I am making sense - if not, I apologize!)
-
@Ashley Greenwood Would you want it to count (for example) 2 if there are two of the possible selections made in the same cell, or would that just be a count of 1?
-
@PaulNewcome I would want it to only count once. Thank you.
-
@Ashley Greenwood In that case we just need to incorporate the HAS function.
=COUNTIFS(CHILDREN(), OR(HAS(@cell, "Line of Business 1"), HAS(@cell, "Line of Business 2"), HAS(@cell, "Line of Business 3"), HAS(@cell, "Line of Business 4")))
-
Thank you, Paul. It doesn't seem to be working, unfortunately.
-
@Ashley Greenwood Are you able to provide some screenshots?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives