List totals

edited 12/09/19 in Smartsheet Basics

I have a sheet that lists all of our clients by project. For reporting, i'd like to see a final report or dashboard widget that lists the clients name in order of most mentions within the original list.

For example: List A

Joe Doe

Freddy Mercury

Alice Chains

Eddie Money

Joe Doe

Eddie Money

Joe Doe


Joe Doe - 3

Eddie Money - 2

Alice Chains - 1

Freddy Mercury - 1


Essentially i'd like a report of how many projects each has.

Is this doable?