% Complete Formulas

Options

Hello and good day I'm getting 3 different percentages when using the following formulas:

=avg(children)): I have one main parent row with several children and getting 42%

=AVG([% Complete]2:[% Complete]195) and getting 35%

Using the project setting and enabling dependencies with % Complete column I'm getting 73%

I need to ensure that the % Complete column is 100% accurate. Please let me know.

Best Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Johnna Van 

    Hope you are fine, you can get the correct percentages if you apply this formula at the parent level

    =AVG(CHILDREN())

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    Hi @Johnna Van

    Is it possible that not all rows from row 2 - 195 are set up as child rows? If some of the rows at the bottom are not indented below the parent row, they wouldn't be included in the CHILDREN function.

    In regards to the % Complete within Project Settings with dependencies, this percentage calculates a weighted average, which is why you're seeing a different number. The Project % Complete takes into account the duration as well as the percentage. (See this Help Article on the Parent Rollup functionality.)

    For example, this means a task which only lasts 1 day does not weigh the same as a task that lasts 10 days:


    Let me know if this makes sense or if I can clarify anything further for you!

    Cheers,

    Genevieve

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!