Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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.
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
