Percentage Complete Calculating Differently on 2 sheets

I have a smartsheet that is pushing data to another sheet. Percentages complete are part of the data that is being pushed. On the source smartsheet it shows 45% for a section. On the Target sheet it shows 63% complete for the sames rows. Can anyone explain why I am getting 2 different percentage completes calculated?

Find more posts tagged with

Forms

Manufacturing

Healthcare

Project Management

Account and User Management

Comments

RossL

If you look at your dates in a Gant view it shows that you have more of the work shown to be done in the second list. the first one the first 3 things on the list only are scheduled to take 5 days where as the ones on the bottom are scheduled to take 10 days.

I hope this helps.

end date.PNG

burkemrich

Indeed it did. I have gone in and copied over the dure dates and it is not the same on both smartsheet's.

Thank you!!!

Sign in to join the conversation!

Quick Links

Trending discussions

I am an Admin, but I cannot edit the workspace
I am already an Admin of a workspace, but when I enter the sheet to edit, it prompts me that I am a viewer. Has anyone encountered this situation? In the share tab, it shows that I am both an Admin and a viewer. How could a product from such a large company have such a BUG?😫
How to recover data after I ran a new workflow and lost my data
The black arrow indicates when (around 4:30pm) the mistake was made. I would like to recover a previous version say around 2pm.
Why is % Complete not the same between Smartsheet and Microsoft Projects
I have two identical projects with the exact same data, but the % Complete in Smartsheet is 14% and the % Complete in Microsoft Projects is 4%. Which one is correct