Project Dependencies enabled but % Complete not working
I've enabled Project Dependencies as shown with the columns assigned. However, the % Complete column is blank and does not auto-complete. Suggestions?
The other supporting columns Start, Finish, and Duration have relevant data. There are some blank Predecessor cells.
I appreciate the help.
Answers
-
Hi @bluefish,
% complete needs to be manually entered. it will automatically roll up to any parent rows if you use indent/outdent.
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
-
Thank you for the rapid response. I'm confused by another forum answer that responds:
If your sheet has project Dependencies enabled, the % Complete column can not have a formula in it. This is assuming that the % Complete column (by name) has been chosen as the % Complete column (by function) under the Dependency Settings | Options section.
Manual entry would seem to contradict this response?
-
I notice if I try to create a formula in the '% Complete' column with dependencies enabled, the formula does not evaluate.
-
Hi @bluefish,
By manual entry, I mean that you, a human, literally type the percentage into the cell. So, say I'm 50% thru, I just type 50 into that column. The sheet then rolls up the percentages to any parent rows automatically. You cannot use a formula to control this if you are using the % complete column.
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
-
Hi @hollyconradsmith ,
Thank you! I understand now.
-
There has to be a start date columns and end date columns on the sheet with dates entered in those rows for the summary value data to be populated and summed correctly on the parent row.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!