Average % Complete for Parent row with multiple Hierarchy levels under them

jnev ✭✭
edited 01/26/24 in Formulas and Functions

Hi all. I'm trying to calculate the Avg for % Complete on my top parent row. That row has direct children but also children who are also parents...if that makes sense. I'm looking to calculate the Avg % Complete of the entire hierarchy below the top parent. AVG(CHILDREN()) only returns the avg % of the direct children, not including what I'm referring to as "grandchildren"

Photo Sample below. Thanks in advance!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!