How to count and rank top 10 from one column of data
Hello. I am trying to create some KPIs in Smartsheet and roll up to a dashboard.
In a column I have a running bid board with customers listed ("Customer Name") as the bids accumulate. In a separate sheet where I am rolling up KPI calculations I want a live count of how many bids (or instances) that customer is listed in that column. This would be very simple to do with a pivot table of course, but cannot figure out how to "roll-up" or aggregate the duplications for lack of better words. In the end I am trying to get a count and rank in order to list out Top 10 customers bidding with us.
I am trying to avoid a standard COUNTIFS formula that is static around key words because the customer list will add new customers all the time and I would like to see how the move up and down the ranking... I hope this makes sense.
Help Article Resources
Check out the Formula Handbook template!