CountIF check boxes error

tobrien3

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)

https://www.smartsheet.com/blog/support-tip-checkbox-formula 

 

What should my formula be instead?

tobrien3

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

Hey tobrien3,

 

great tip!

 

Thanks!!