Summary formula to count the number of rows in a sheet that have no children?!



I've been racking my brain trying to get this formula to work!

I can create a helper column in the sheet and display the number of children each row has, then simply use a CountIf function - if Children=0, but, I thought i could use a COUNTIF with @cell to not require the helper column?

I have tried the following

=COUNTIF({Ref Col}, COUNT(CHILDREN(@cell))=0)

Thank you


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!