Counting Children

Eddie Abasta

What formula do I use to get a count of sub tasks under a particular task Parent/Child?

Jenny Lam

Please try =COUNT(CHILDREN(...)). For more details, see: http://help.smartsheet.com/customer/portal/articles/775363#hierarchy

Eddie Abasta

That did the trick!  Thank you so much!

Brad Jones

Now,

 

How do you count the "sub-children" or "grand children"??

For example, I have a main task, with three sub tasks, each of which has 12 sub tasks.  So, in total, I have 3 children and 36 "sub-child" tasks.  How do I count these?

 

Do I have to do a sum of the children of three tasks ??   (i could figure that one out, but would prefer something more elegant.

Travis

Brad, do you want the result to be 36?

 

Add =COUNT(CHILDREN() to the three children and =SUM(CHILDREN() to the main parent. 

Brad Jones

Thanks Travis.

 

That is effectively what I had to do.  I used this, and just saved the =SUM(CHILDREN())

=COUNT(CHILDREN(Room245)) + COUNT(CHILDREN(Room276)) + COUNT(CHILDREN(Room285))

This gave me 36.

 

But the answer, in the end, is that grand-children counting is not supported in a formula or function yet.  

J. Craig Williams

Column 1: [Value]

Formula:

=SUM(CHILDREN())

 

If user enters a value (for the grand-children for example) the formula is a gone and that's OK unless this later becomes a parent. Lock the row if you can.

 

Column 2: [Sum]

Formula:

=IF(COUNT(CHILDREN(Value23)) > 0, SUM(CHILDREN(Value23)))

 

for Row 23.

This will sum all children and grand children (and great-grand children too)

Cell will be blank for non-parents.

 

 

Craig