Embedded formula for Parent & Child
I am trying to embed a formula for a column (percent completion) for all PARENT rows to show the average of the CHILDREN rows and am having to past the average formula into each parent cell. Is there a way to apply the formula to the entire column to automatically capture averages in the parent row while still being able to manually update the child % completion?
Help Article Resources
Check out the Formula Handbook template!