Formula If Then

Sheet A: Primary sheet that lists employee data (name, ID #, supervisor, training a, 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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!