Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Descendants vs Children

edited 12/09/19 in Archived 2016 Posts

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!

This discussion has been closed.