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

Jason2
Jason2 ✭
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.

Tags:
· Share on FacebookShare on Twitter

Comments

  • Shaine Greenwood
    Shaine Greenwood Employee

    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!

    · Share on FacebookShare on Twitter
  • Jason2
    Jason2 ✭

    Thanks.

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories