Project Dependencies enabled but % Complete not working

Options

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 ✭✭✭✭
    Options

    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
    Options

    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
    Options

    @hollyconradsmith

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

  • hollyconradsmith
    hollyconradsmith ✭✭✭✭
    Options

    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
    Options

    Hi @hollyconradsmith ,

    Thank you! I understand now.

  • Shane Sorensen
    Shane Sorensen ✭✭✭✭
    edited 03/02/22
    Options

    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!