% Complete is not calculating properly

Joel Frenette

I have a Smartsheet Project Plan and the % Column is not adding up correctly.

see

Andrée Starå

Hi @Joel Frenette

I hope you're well and safe!

Have you checked the Project Settings?

https://help.smartsheet.com/articles/765755-modifying-project-settings

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Joel Frenette

Options for % Complete are correct, but the Summary or Parent Row is not calculating all the child , indented tasks correctly.

Andrée Starå

@Joel Frenette

Have you added any duration to the rows?

Laurie Gendron

I am having the exact same issue. Duration is added to the rows, project settings are consistent with Joel's.

I will add, only some project tasks are having this rollup problem- not all.

Thanks!

David-Silva

Was this ever resolved? I'm having the same issue!

David-Silva

I think I may have figured it out. Make sure your duration is calculating properly. I just noticed that for some new tasks I added even when I setup the start and end date, maybe because they were the same, the duration was 0. I changed the end date to the next day, which changed duration to 2 days and the % complete calculated properly. I changed the end date back to the original date and it's still working!

Ryanne Kwan

I have the same problem. Duration is working properly but the complete % isn't adding up properly.

Elizabeth Smiley23

Hello,

Did you guys every find a resolution to this issue?

Thank you

Sorida Sours

I have same issues, below solution is working for me, hope that could help you as well!

I have a column to count the children row =COUNT(CHILDREN())

Then the "% Complete" column, I use this formula

=IF(Children@row <> 0, AVERAGEIF([% Complete]40:[% Complete]45, <>"", [% Complete]40:[% Complete]45), "0%")