Project Dependencies enabled but % Complete not working

image.png

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

  • hollyconradsmith
    hollyconradsmith ✭✭✭✭

    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

  • bluefish
    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
    bluefish ✭✭

    @hollyconradsmith

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

  • hollyconradsmith
    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.

    Holly Conrad Smith

    Director of Technology & Innovation πŸ’‘ at Streamline

    CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony

  • bluefish
    bluefish ✭✭

    Hi @hollyconradsmith ,

    Thank you! I understand now.

  • MrDramaFree
    MrDramaFree ✭✭✭✭
    edited 03/02/22

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!