How to count values in drop down
I have a training tracker that Managers complete the form to then update the tracker. However I want to be notified when 10+ students have registered for the same course. I will add some screen shots but i.e. if more than 10 ppl register for "Auto" then I would like a count of how many.
I added a column per Module but then that give me extra columns. Is there a way to have maybe a helper column that can then show how many students per module?
Any assistance would be appreciated
Answers

You will probably need to create a separate metric sheet to compute the values and have a workflow in that sheet that notifies you when the count of students exceeds a certain number of your choice. In the metric sheet, For Auto Module as an example, you will have a formula =COUNTIF({Reference of the Module Type}, [Primary Column]@row). Assuming Primary column in the new metric sheet is where you would have the value Auto Module. You can then add values to other rows of the names of other modules you will be tracking and just drag the formula down to get student counts for other modules.
The workflow would be an alert workflow where you can define a condition as the value in the column containing the counts is greater than 9, as an example.
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!