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

Options

Hi,

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!