Children Sum if Column has a check
Hello! I am needing help with a children formula, that I feel like should be basic but I am not having any luck. I need the parent row to sum up the children rows that also have a certain column checked. Can anyone assist? Thanks!
Answers

Hey @alumweb
Try this.
=SUMIFS(CHILDREN([column name to sum]:[column name to sum]), CHILDREN([checkbox column]:[checkbox column]), 1)
SUMIFS have the syntax SUMIFS(Sum range, criteriarange1, criteria1, criteriarange2, criteria2, criteriarange3, criteria3, etc).
If you add more criteria, be sure to add it as a criteriarange, criteria pair. Change the column names to your names.
cheers,
Kelly

It looks like this formula works, except I am not trying to sum numbers in a column, I am trying to count a row if a box is checked. I am sure it is because I do not understand how to put it into a formula.

Hey @alumweb
Sorry, I misinterpreted your statement that you wanted to sum up the children rows.
To count, we use one of the counting formulas. Since we only want the children that are checked, we will use COUNTIFS which allows us to insert criteria
Your checkbox column is expecting a 1 or 0 so your formula should reside to the side in a Text/Number column
=COUNTIFS(CHILDREN([name of your checkbox]:[name of your checkbox column], 1)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!