Sign in to submit new ideas and vote
Get Started

Grouping a multi-select and/or multi-contact Column on Report

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.

10 votes

Idea Submitted · Last Updated


  • Erica L.
    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
    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.

  • 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
    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
    KevinHarrisCHT ✭✭✭✭

    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.

  • dsugde
    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.