How can I add a percentage column that tracks progress of each line item that is considered a "Task"
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.
Answers
-
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.
-
The % Complete option also needs to be set to the correct column name in the Project settings for this to work.
-
Do I have to enable the Dependencies in order to get the percentage to pop up in the % Complete column?
-
Yes, the Dependencies need to be enabled as well.
-
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.
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives