Counting Parent Rows

Autumn Montegna · 05/17/21

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 · 05/18/21

Hi,

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.

Help?

Mark

Answers