Project Plan Template Formula Issue
I have a question on a formula used in a project plan template currently being used.
Many times, the % complete (expected) is greater than 100%. The formula currently being used is Expected Effort Complete/Cumulative Effort.
The Cumulative Effort is the duration of the task, in days, and the expected effort complete formula is IF(TODAY() > [Planned Finish]@row, Duration@row, IF(TODAY() >= [Planned Start]@row, TODAY() - [Planned Start]@row, 0)))
I cannot figure out where the formula error is that is giving me a greater than 100% expected complete figure.
Help Article Resources
Check out the Formula Handbook template!