Formula help: Cross-sheet formula count checkboxes for children only
I'm looking for help with a cross-sheet formula that counts selected checkboxes in a column but only counts child rows, and only where the user name is not blank.
I have a checkbox column for Parent and also a helper column identifying parent numerically (0/1). I haven't been able to figure out a formula that works. Any help appreciated!
Best Answer
-
I think a COUNTIFS formula will do what your need. You can include multiple criteria and the formula will count where all are true.
Your criteria will be:
- The username is not blank.
- The row is a not a parent (using the checkbox column you already have).
- The checkbox you want to count is checked.
So, if your data looked like this:
The formula would be:
=COUNTIFS({Reference to Name column}, <>"", {reference to is parent column}, 0, {reference to boxes to count column}, 1)
Hope that helps.
Answers
-
I think a COUNTIFS formula will do what your need. You can include multiple criteria and the formula will count where all are true.
Your criteria will be:
- The username is not blank.
- The row is a not a parent (using the checkbox column you already have).
- The checkbox you want to count is checked.
So, if your data looked like this:
The formula would be:
=COUNTIFS({Reference to Name column}, <>"", {reference to is parent column}, 0, {reference to boxes to count column}, 1)
Hope that helps.
-
Yes, worked perfectly! Thank you!
-
Great news. Glad I could help.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!