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.
