Counting Child Rows of Un-Checked Boxes

Elaine Wright · 04/06/16

Any tips in how to count child rows where the check box is not checked?

I tried CountIF but it does not seem to work

Thanks

Elaine

JamesR · 04/07/16

Check boxex expect a 0 or 1 or Text. There fore if the calculation does not produce 0 or 1 then it errors.

Try this:

=COUNTIF(CHILDREN(), 0) + " of " + COUNT(CHILDREN())

JohnHinkle · 04/07/16

James is correct, you will need to format the result as a text string (if this formula is in a checkbox cell) because the checkbox column is looking for a 1 or 0 as a result.

=COUNTIF(Complete2:Complete14, 0) + ""

The + "" at the end will format the result as a text string.

Elaine Wright · 04/07/16

Thanks for the feedback James and John but neither one is working

J. Craig Williams · 04/07/16

This works for me:

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

Post a screen shot if you didn't find it yet.

Craig

Elaine Wright · 04/08/16

J.Craig- Bingo, that one worked. Thanks!

Welcome to the Smartsheet Forum Archives

Counting Child Rows of Un-Checked Boxes

Comments

Categories