CountIF check boxes error

tobrien3 · 07/14/16

Using the formula =COUNTIF(CHILDREN(), 1) in my check box column and it throws the error #1 or 0 expected.

There's an article explaining to do it this way (unless I am misunderstanding)

What should my formula be instead?

tobrien3 · 07/14/16

Figured it out. For anyone else experiencing the problem, use

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

Formats the cell as a text string instead of checking for a 1 or 0 (checked off or not)

Dietrich Koch · 07/14/16

Hey tobrien3,

great tip!

Thanks!!

Comments