Grouping a multi-select and/or multi-contact Column on Report
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.
Comments
-
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.
-
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.
-
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
-
I'd love this too! Ideally how would you want it to behave? There are a lot of permutation possibilities with grouping multiselect dropdowns.
-
Would be great to be able to use a row report and group and count by the multi-select dropdown column.
-
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.
-
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.
