Creating an average based on 3 different sheets

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!