Formula for Average Number of Shifts to Complete New Hire Orientation
Hello All,
Beginner Smartsheet user here. I'm working on trying to get the average number of new hires off orientation. Each department is tracking how many shifts of orientation a new hire is taking before they meet the criteria to be signed off.
The number of shifts can be anywhere from 1  20 (see Avg Shifts column)
I created a metric sheet that is pulling in how many new hires completed a shift for each number. I used the average function =AVG( however, this is incorrect because it's averaging the number of new hires in the department column instead of the average number of shifts. Does anyone have any suggestions on a formula? Do I need to reorganize the metric sheet differently?
In the screenshot below, department B2 has 1 new hire who has completed orientation after 6 shifts. Department B2 has two employees who have completed their orientation after 6 shifts.
Answers

Ok so, send your formula over and a screenshot of your metrics sheet. Also, would the Avg Shifts really just be the number of shifts the new hires did before they completed orientation? Calling that the Avg Shifts is a bit confusing since its not really the average, just the count of shifts each employee did before they completed orientation.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!