Why is the overall % percent project complete showing 99%?

Help please. I am testing the plan rollup template. My question is why is the overall % percent project complete showing 99%?

Initiate = 100
Planning & Discovery = 1
Build & Implement = 0.99
Closing = 0

Answers

  • Michelle Choate 2
    Michelle Choate 2 ✭✭✭✭✭✭

    It bases the percentage on the children. Since you have raw numbers in 3 of the children, it sees them as percentages. In this case, 1 = 100% and 0.99 = 99%. So it is understandable that it is seeing 99% for the total.

    It is weighted based on the number of tasks for each section. So if you have 100 tasks for Initiate and 10 tasks for Planning & Discovery, it is going to be more heavily weighted to the Initiate complete percentage.

    Michelle Choate

    michelle.choate@outlook.com

    Always happy to walk through any project you need help with!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!