% Complete Manually Formula

Options

Smartsheet Community:

I need to Manually calculate the % Complete for the Parent Task because I want to use a formula for the children. Does anyone have the formula that the Automatic Project Settings use for % Complete?


Thanks

Answers

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭
    edited 06/04/20
    Options

    Hi Ray

    I have had a quick look and play with this and if your manual % complete column is formatted as a % (i.e. you've used the % button to format the column) then putting this formula in the parent row should summarise it appropriately

    =SUM(CHILDREN()) / COUNT(CHILDREN())

    I hope this helps

    Kind regards

    Debbie


  • Anthony Barthelemy
    Anthony Barthelemy ✭✭✭✭✭✭
    Options

    That helps, but I need a weighted average. I used the Following % to compare to the automated % calculation set in the Project Settings of Smartsheet:

    Formula % Calculation was 20%


    Automated (Smartsheet Project Settings)

    Summary Task % =30%

    Task 1 20%

    Task 2 40%

    Task 3 60%

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭
    edited 06/05/20
    Options

    Sorry Ron

    I have been playing with it for over an hour and I can't work out the algorithm. It is linked to the duration.

    I'll carry on thinking about it though...

    Kind regards

  • Anthony Barthelemy
    Anthony Barthelemy ✭✭✭✭✭✭
    Options

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!