Project Dependencies enabled but % Complete not working

bluefish

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.

hollyconradsmith

Hi @bluefish,

% complete needs to be manually entered. it will automatically roll up to any parent rows if you use indent/outdent.

bluefish

Hi @hollyconradsmith

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?

bluefish

@hollyconradsmith

I notice if I try to create a formula in the '% Complete' column with dependencies enabled, the formula does not evaluate.

hollyconradsmith

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.

bluefish

Hi @hollyconradsmith ,

Thank you! I understand now.

Shane Sorensen

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.