How can I add a percentage column that tracks progress of each line item that is considered a "Task"

AshelyBee · 12/14/21

I'm creating a project tracking sheet that tracks the progress of multiple projects. However, I've been asked to track completion of a project by using percentages. I'm not sure how this is done. I have a Start date but the End date only appears once I enter it in.

Jason Duryea · 12/14/21

If you have a % Complete column in your project schedule, the PM can update this for each task. The % Complete for all child tasks will then rollup to the Parent row. See the example below. Pay attention to the Parent/Child tasks and % Complete. In this example, the Start and Finish dates are irrelevant since the % Complete is manually entered by the PM. A formula is not required for the % Complete to rollup on Parent/Child rows either.

Jason Duryea · 12/14/21

The % Complete option also needs to be set to the correct column name in the Project settings for this to work.

AshelyBee · 12/14/21

https://community.smartsheet.com/discussion/comment/313476#Comment_313476

Do I have to enable the Dependencies in order to get the percentage to pop up in the % Complete column?

Jason Duryea · 12/15/21

Yes, the Dependencies need to be enabled as well.

Andrew W. · 03/22/24

I have dependencies enabled; however, when I open the project settings box the options for % Complete column are: None, Description or % Allocation. There is no option for a % Complete column.

Jake Kenyon · 03/29/24

You will need to add a column called % Complete which is the text/number type, then it should allow you to select it. Hope that helps if you haven't already sorted it out.

How can I add a percentage column that tracks progress of each line item that is considered a "Task"

Answers

Categories