How to count values in drop down

Roshni Verappan

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

AravindGP

Hi @Roshni Verappan

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.