Issue with CountIf not correctly calculating

Katye Reed
Katye Reed ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions


I am using the formula =COUNTIF(CHILDREN(), 1) + "" to count the total number of checked check boxes. However, The number displayed is 0 when I can clearly see the box is checked in that column. 

For other columns it displays a number but not  an accurate count of checked boxes within the column.

Is there a different formula I should be using?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!