Averaging Health Status for Parent Rows based on Average of Children Rows in RYG.


Hi everyone,

I am looking to find the best formula to give me the average health status in RYG for the parent rows (#2). I have tried IF formulas but keep getting parsed errors. Please help.

Also looking to get the formula to the sub row (#1- where the picture says strategy session or AI POD etc) to the parent as well. Any insight would be largely appreciated.

Please note, the status for the RYG are based on the Status column on the right.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!