% Complete in Project Template seems to be off.


Working in a Smartsheet Project Template. I've put in my % complete info for each WSB row. The Parent % complete is reporting back 21%, while a selection of the rows shows that the average should be 19%

Does anyone have a logical explanation for this?

Best Answer


  • Andrew Schleicher

    What is the formula being used to calculate these percentages, particularly for the parent row?

  • Michael Macygin

    I'm not relying on a formula here. The Parent Row is being auto calculated by the Project Template I'm using. I'm just placing % Complete data in the Children rows and allowing the template to auto calculate. As a matter of fact, when I try to make any changes to % Complete cell in a Parent row, I get the the following message from the platform.

  • Purnima Gore
    Purnima Gore ✭✭✭✭✭✭


    I had a similar issue as the plan was showing 0 or 100 and I knew there should be a different number in the roll up.

    I needed to ensure that the start and end dates were added to the plan in order for this to work.

    Hope that helps.


    Purnima Gore

    Cierr Limited

    Your Time is Important, you want to Stay on Track, We can help you use the Right Tools


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!