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.

FORMULAS

Brian Barr
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.

Tags:
· Share on FacebookShare on Twitter

Comments

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

    Brian,

     

    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)

     

    or

     

    =AVG(range)

     

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

     

    Hope this helps.

     

    Craig

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories