Calculating the Average of Descendant Rows
Hi there, I am having some trouble calculating the average of the "RYG Average" column for the child rows in my Smartsheet. I have a helper column called "Parent Row" that has a checkbox for any rows that are considered parent rows. I am wanting to calculate the RYG Average for the child rows under each parent row. Here is the formula I have been using:
=AVG(COLLECT(DESCENDANTS(@row, [Parent Row]:[Parent Row]), [RYG Average]@row))
but Smartsheet keeps saying that this is #UNPARSABLE. I am wondering if this is due to the fact that the hierarchy has multiple levels. For example, the "Security" parent row also has a few subdepartments that fall under it that are also parent rows. I want to calculate the average for "Security" as well as it's subfunctions. Any guidance you can offer would be much appreciated as I am new to Smartsheet.
Answers

Are you able to provide a screenshot for context?

Here is a photo for context. You can see Security at the top with several subdepartments underneath. Each subdepartment has various tasks. I want to calculate the RYG Average of Security and each subdepartment (SecOps, ProdSec, SA&T, and IAM, respectively).

In that case, I would suggest just putting the average on each parent row which will in turn feed up to the next level.
=AVG(CHILDREN())
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 123 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!