How do I count the number of times a "Staff Person" selected a dropdown option?

In my original sheet there is a form staff can fill out to request passes. I'd like to count the number of time each staff person requested a pass and what pass they requested.

In my metrics sheet the "Staff Name" column has all the names and the other columns would hopefully be where number of "Parking Pass"es the staff requested.

Any help with a formula would be great. My end goal would be to create a dashboard with all this information.

Thank you in advance for your help.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!