% Complete Manually Formula

Anthony Barthelemy
Anthony Barthelemy âś­âś­âś­âś­âś­âś­

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

    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 âś­âś­âś­âś­âś­âś­

    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

    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 âś­âś­âś­âś­âś­âś­

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!