Running a report with multiple drop-downs
I am running a QI report where we are looking at any kudos for our agents. We want to recognize our top performers, and we have a sheet where we collect that data for specific agents and incidents. On most incidents there will be 2 or more agents receiving those kudos, so we created a multiple select drop-down to enter the agents names to receive those kudos, and run a quarterly report which counts how many kudos each agent has received.
So I have been able to create the report using a single select drop down column for the agents names, but I can't the same report to work using the same data using a multiple-select drop-down column in the sheet. What am I doing wrong?
Help Article Resources
Check out the Formula Handbook template!