Parent Row Calculation


I want to know how exactly the the Complete % of the parent row is calculated by Smartsheet.

I though it was the average of the child row but I think I am wrong.

As per the attached picture you can see the average of the Complete is % 0.24 i.e 24%

where as in the parent row its only 12%.

Please explain me how the parent row calculates the Complete %?


  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 04/12/21

    Hi @Anoop Phago

    Hope you are fine, it's not the average it's weighted average using AVGW function and it use the duration as a weight.

    PMP Certified

    ☑️ 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"