Formula for a checkbox column
I have searched all the forums for the formula for the checkbox sum & none of them have worked for me. I need to total the sum of the checkboxes that are checked within a column.
Comments

I just needed to do this today.
enter '=COUNTIF', then select the entire column, and put '1' for checked.
=COUNTIF({On Track}, 1)

I don't know why, but its not working for me. I've tried this several times. I either get "unparseable" or Boolean Exp message.

It worked if it is not in the same column as the checkboxes! Is there a way to make it part of the same column so the totals are below the boxes?

If you make all of the lower rows Child rows (indent them) below the summary row, you could use...
=COUNTIFS(CHILDREN(), 1) + ""
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!

@Paul Newcome this formula helped me tremendously! Now I am facing another challenging. I am now trying to SUM the COUNTIFS totals using a CHILDREN formula to show the overarching total. I have attached an image. When I just try a general =SUM(CHILDREN( formula, nothing populates in the cell and I still see the checkbox. When I tried totaling manually at one point, instead of a SUM I somehow merged the numbers into a string (i.e. instead of 5 + 4 + 1 creating 10, I got 541).
Any suggestions on how I can total up the 23 + 17 + 1 + 0 + 0 + 0 appropriately in the North America row?

@Jen V I am at a similar situation. Did you find a way to sum in the checkbox column?
Thanks in advance.
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 379 Global Discussions
 213 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