I have a sheet for tracking the amount of defects that occur. Each defect report has a "Machine Name" value which is selected via a dropdown. What I'm trying to achieve is to have a counter, in any form but preferably a widget or a column, that would track the amount of times a report pulls a machine name. I.E. if Machine 1 has 3 reports on my sheet, this value would be recorded. Essentially, I want to track the number of defects that come out of a machine.
I tried making a widget for this, but the data wouldn't work I assume because the values aren't numerals (machines are like A-001 or W-034).
Is this possible? Thanks.