Cant get % Complete to populate
H-I have enabled dependencies, % Complete column is Text/number, all Plan Start and Plan Finish dates are in date format, Duration column has values, yet %complete does not populate. What could be the problem?
Answers
-
Hi @HFN
The % Complete column in a project plan will only automatically update on Parent rows, providing a summary of the child rows below. (See: Parent Rollup Functionality). For the child rows, you will need to input the % complete manually.
If you don't want to enter this manually, you can take away the % Complete field from your project settings and then create a formula to auto-populate all rows (see: Project Sheet Columns: Start Date, End Date, Duration, % Complete and Predecessors)
If you want to go the formula route, can you identify what percent you want to show based on the content in your sheet? Ex. do you want this to be date based, so dependent on when the task started, when it's due, and what today's date is? It would be helpful to see a screen capture of your sheet, but please block out sensitive data.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!