Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
How can formulas be run against all Descendants of a Parent row, rather than only direct Descendants (Children)?
Example: =SUM(DESCENDANTS())
Thank you.
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!
Thanks.
