Counting Children Rows

Can anyone advise how to count children rows please?

I have tried several examples from the net but none seemed to work, though i did get this

=COUNTIF(CHILDREN(), 0) + "" to work for one row (without the additional criteria of checking if a checked box was checked) which gave the correct number 3. when i converted this to a column formula the 3 changed to 0!!

I just need to count open children rows for a report but can't figure it out which replicate when i convert to column formula

Thank you

Barry

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!