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

Kidco Head Start

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.

Kelly Moore

Hey @Kidco Head Start

The easiest way to accomplish what you need is to create a row report. You would then Group by Staff Name, then by Pass Type. You would summarize (count) by each grouping. A report will be evergreen - if you add different people or different types of passes, the report will automatically include this data and will always be up to date. I strongly encourage you to go this route

You will be able to put this information on your dashboard.

https://help.smartsheet.com/articles/2482078-build-a-row-report-with-report-builder

Will this work for you?

Kelly