Rollup percentage in project schedule template is not calculating correctly

I'm using the project template in smartsheet, in grid view. I've broken my project up in several phases, each phase a parent with child tasks. The Project % complete is coming out as 99% complete, but it is far from being that complete. Is there something I have to do to get this to calculate correctly, or do I have to manually do parent/child formulas? If so, I would of though that the project smartsheet template would of handled that.

Please note that if I start a project with or without the Project information (first 6 rows of the project detail) the % complete doesn't change.

Find more posts tagged with

Templates

Sheets

Comments

Paul Newcome

I would suggest checking which columns are being used in your dependency settings first.

Paul.Koetke

Hi Michele,

Great question! When using the % Completed column in the Project Settings, it calculates a weighted average. Since so many of your tasks do not have dates or a duration their weighting is zero. If you add expected dates, you'll see the % Complete update accordingly.

Let me know if this answers your question.

Paul Koetke

Upwork - Smartsheet Consultant

Sign in to join the conversation!

Quick Links

Trending discussions

Solution to manage accidental deletion
Good afternoon, Recently we have started one of our sheets in Card View and on a handful of occasions, we have had users deleting cards (or rows) from the sheet, simply by clicking the delete button on the keyboard by accident. I have done a manual test on a copy of the sheet and doing so does not prompt the user to ensure…
Submitting forms for approval
Any help would be greatly appreciated! We have a 3-step process for travel approvals. I am able to get the forms to the correct people. I now have a request for the ability to add comments during the approval process. Staff submit request via Smartsheet form Automation forwards the form to the manager for approval Once…
Why would an automation for movement not carry over a cell value?
Hi everyone, I’m running into an issue with one of my sheets and was hoping to see if anyone else has experienced this. Here’s the setup: I have a sheet where, when I check a box, the row moves to a “Completed” sheet. In my Total column, I use a formula that sums a group of cells tied together via a parent/child…