Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Avg of Parent not matching up to Avg of Children
I'm trying to roll-up % effort at the project level based on % effort entries at the task level. I'm using the formula avg(children()) at the highest level to get the roll-up total.
As a check, I'm calculating the avg % effort at the highest parent level throughout the plan.
I'm running into a situation where my rolled-up avg % effort (tasks level) is not equal to the avg % effort (parent level). This should be equal.
Am I using the Children() formula incorrectly? If so, does anyone have any idea on how I can get the information I need?
So far, I can avg the % effort of the highest level parents with the criteria of ParentID and Ancestor = 1. This gets me 52% vs 46% using avg(children).