Group Multi-Select Dropdown and Multi-Select Contact Columns within Reports

It would be great if we had the option to group line items in a report by options selected in a dropdown column.

Ex. If you are viewing projects within a global campaign and have "country" as a column with the fixed values for all the available countries. It would be nice to be able to run a report where you could group the projects by the countries that were selected in the country column.

Not sure why this isn't an option but this seems like an incredibly useful feature that would improve the functionality of reports.

Sign in to vote!

Find more posts tagged with

Reports

On Wishlist

report column

Comments

balfonso

This is a copy and paste from the Smartsheet Basics community. I am having the same issue and would like for this functionality to be added to Smartsheet.

Grouping a Multi-contact Column on Report

I want to group a contact column with multiple contacts on a report to have a visibility of the tasks assigned to the the contacts.

When I look for the column under the group dropdown, the column des not appear. However, when I uncheck the allow multiple contact per cell button, the column appears.

So, I want to find out if a contact column (with allow multiple contact) can be grouped.

Erica L.

Yes, would be great if we could Group a report by the Assigned To column when the same column at the source sheets is a Multi-Select please! Thank you.

dhall

When trying to group by a column that has "Allow multiple" selected, no matter how many contacts are in a cell, it will give you this warning:

Then the grouping is generic and is not helpful:

I would prefer it break it out by each contact, and then if a cell has multiple contacts, repeat the row for the other assigned contact in THEIR grouping section of the report.

Tim C

My closest workaround for a multi-selct dropdown was -(I did this for an assignee column so I could group the report by the assignee.)

I changed the column to only allow a single entry, which then allows you to group by column, then i created a secondary and tertiary assignee column as well. I just summed all the assignee columns.

But I agree, the enhancement would be great!

Matthew L

@Tim C , I like this workaround but agree there are still many uses for being able to sort by drop downs where multiple values could be submitted.

Like in the country example I used above, if you had a project that was taking place in Italy & Spain you'd want to see that project show up under the Italy grouping as well as the Spain group in a report.

Kamila KP

Yes! This option would be be very helpful. I have a lot of worksheets with multiple dropdown lists and I'd benefit from an option to group them on a single report

Tim C

I'd love this too! Ideally how would you want it to behave? There are a lot of permutation possibilities with grouping multiselect dropdowns.

KevinHarrisCHT

Would be great to be able to use a row report and group and count by the multi-select dropdown column.

balfonso

Tim,

It would be best that a line item on a sheet can be assigned to multiple people. Then when I create a report the line item is assigned to multiple people.

dsugde

Currently there appears to be no ability to extract out the individual values of a multi-select column and report on them without the application of lengthy and complex queries. This is not ideal. What I want to be able to do is create a report that groups things by request and shows individual line items for each multi-select value.

matt.macfarland

This would be a great enhancement. It seems straightforward -- each group would just be inclusive if the relevant dropdown item is present in the cell, regardless of whether other items are there too. In my case, I have a "tags" column with 3-5 tags, and want a given row to be in every relevant tag group.

C_Torres

Currently, you are unable to Group your content together by every Column that you input. It would be great to be able to Group our content/data by all headers that we input.

Currently, I would like to Group my content by "Tactic" (Email, DM, etc.) but it does not give me the option.

Kam114

Would really love to see this as well. Would ideally like to avoid having to create separate columns for multiple contact columns.

Tim C

https://community.smartsheet.com/discussion/comment/403972#Comment_403972

100% agree with you! The work around is not idea.

Sarah Butterworth

It would be very handy to be able to group by a column even if that column is a multi-select column. Thank you

Quick Links

Trending ideas

Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…