Descendants vs Children

Jason2

How can formulas be run against all Descendants of a Parent row, rather than only direct Descendants (Children)?  

 

Example: =SUM(DESCENDANTS())  

 

Thank you.

Shaine Greenwood

Hi Jason—Smartsheet doesn't currently have a "descendants" function but I'll get your vote down for this on our enhancement request list for further consideration.

 

One way to go about this, if possible, is to place =SUM(CHILDREN()) formulas in your "descendants" rows. Those rows will sum their children, then the higher level parent rows will use this value when summing their children.

 

Thanks for the input!

Jason2

Thanks.