Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.


Brian Barr
edited 12/09/19 in Archived 2017 Posts

I have a smart sheet for job progress I have indicdual lines of % of jobs what formula do I use at the top to get the overall % of all jobs.



  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭



    Are they all weighted equally or is percentage based on total cost, total effort, or total duration?


    Simple weighting would be something like


    =SUM(range) / COUNT(range)






    You might also be able to leverage weighting using AVGW()


    Hope this helps.



This discussion has been closed.