Creating an average based on 3 different sheets
I'm trying to create an average based on 3 different sheets. Right now I have 3 sheets (Tracker, Completed, Dead) these all have a summary calculation to give me the total number of sites for each developer. I'm trying to create a number for each developer that tell me how many sites get completed on average.
Right now I know how many are live and how many die & how many they have completed but I need to get a number of how many get completed based on an average.
Answers

How are you currently pulling your counts for each of the individual stats?

I'm using summary on each sheet to count the developers names. This is the same formula for each sheet. I assume I'll need to create this info on a new sheet to get the counts for each but I'm not sure of the formula to make this work.

You are going to need to replicate these counts into a helper column on the sheet itself. Then you can use cell links or formulas with cross sheet references to pull these into a "master metrics" type of sheet.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 200 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!