Weight of a Category in my Construction Project Plan

Dear Colleagues,

If anyone has come across this requirement, please share how to solve it. I have various categories in my project plan: Indoor Works, Outdoor Works, Testing and commissioning etc. Each category like that has a weight in a project. My colleagues who are already using the plan have manually filled in the % Complete column that rolls up completion from children to parents. Now I am asked to add weightage.

My natural thinking was that I should add a new column to add Weight, then add a new column to calculate % Complete * Weight. Not sure this is correct...

Thank you,



  • Intern98
    Intern98 ✭✭✭

    It is correct but many columns may be untidy, messy etc

    you can try using

    =IF([Category]@row = X , Weight of X* [% Completed]@row,

    IF([Category]@row = Y , Weight of Y * [% Completed]@row,

    IF([Category]@row = Z, Weight of Z * [% Completed]@row,

    IF([Category]@row = A , Weight of A * [% Completed]@row, ))))

    For as many category variable as you have replacing the x,y,z,a respectively and adding more if required in the nested if loop

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!