Counting Check Boxes

MVigrass

I'm trying to get a formula to count the number of Check Boxes that are checked in all the Children rows under a Parent row.

 

When using ="Count:" + COUNTIF(CHILDREN(), 1), which is one of the formula examples I'll get this Count: 2

 

All I'm looking for is the number so I tried =COUNTIF(CHILDREN(), 1) but it doesn't work.  All I get back is #1 or 0 EXPECTED.

 

Any help would be appreciated.  Thanks.

Brett Evans

MVigrass,

 

Click on a cell to see the formula

https://app.smartsheet.com/b/publish?EQBCT=636085f90ff64e05910d078bf2191f60

 

This is definitely doable.

MVigrass

Thanks for that.  I was looking at that type of formula too, but was hoping to be able to do the count within the same column at the parent level to keep things simple.  

 

Travis

MVigrass, when you add a formula to a checkbox cell, the cell is expecting a 1 or 0 as a result (1 = checked 0= unchecked) if the result is a number. Your first formula worked because the result was formatted as as text string and not a number (because you had "Count:" +). Use this trick to format the result as a text string but show only the number in the parent row:

 

=COUNTIF(CHILDREN(), 1) + ""

PLorimer

Thanks Travis. This is the trick I've been looking for.