Creating a Report

MarcelleM

I am trying to create a report using 5 columns from one sheet. However when I try to "Group By" not all 5 columns appear in the dropdown and under summarize, the 5 columns are also not available.

Does anyone have any advise?

Paul Newcome

There are certain column types that will not work for this. I have found that anything multi-select (dropdown and contact) will not be available for grouping.

Paul Newcome

There are certain column types that will not work for this. I have found that anything multi-select (dropdown and contact) will not be available for grouping.

MarcelleM

Thank you so much. That worked :-)

Paul Newcome

Happy to help. 👍️

MarcelleM

Do you perhaps know how to not count duplicate names?