Summary report where multi-choice dropdown list is used

Michał Wichowski

Dear Community,

I am struggling with creating summary report for one column, where multi choices could be picked.

Is it possible to summarize this? I would like to make a nice looking dashboard out of this, but when I click summarize, column where choices are is not present, it is empty.

Paul Newcome

Here are some search results:

https://search.smartsheet.com/community/#q=distinct%20values&sort=relevancy&numberOfResults=25

Paul Newcome

We are currently unable to group by multi-select dropdowns or contact lists although it would be really great if we could.

There are a number of solutions floating around here in the community that will show you how to pull together distinct/unique lists and then parse them out in another sheet so that you can then set up a metrics sheet.

Michał Wichowski

Thanks Paul, would you be able to link me to one of such solutions?

Paul Newcome

Here are some search results:

https://search.smartsheet.com/community/#q=distinct%20values&sort=relevancy&numberOfResults=25