Formula If Then

Sheet A: Primary sheet that lists employee data (name, ID #, supervisor, training a, training b...training g, avg training completion)


Sheet B: I want to write a formula that shows per supervisor, the average training completion of all of their staff. How do I write this formula to pull from sheet A and then average numbers in the last column but only if the supervisor in an earlier column matches?


For reference, my end goal is to make a dashboard with this information for supervisors to see, but I think I need data consolidated from Sheet A on to Sheet B to use for the dashboard.


Thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!