Formula help: Crosssheet formula count checkboxes for children only
I'm looking for help with a crosssheet 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!