Counting Parent Rows


Good Morning,

I have smartsheet Parent and Child rows. How do I count the parent rows? Also, how do I COUNTIF for parent rows that meet a certain criteria?

Thank you so much for the help!


  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭


    Create a text/number helper column [level] with the formula =Count(ANCESTORS()).

    Parent rows will have a value of 0. Use level:level, 0 in your COUNTIFS formula to include parent rows.

    To add other criteria your formula will use the syntax::

    =COUNTIFS( level:level, 0 , [other range]:[other range], Other criteria)

    For help with formula syntax see the link below.



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!