Multi Select Column in Reports

Lauryn Vogt
Lauryn Vogt ✭✭✭
edited 12/09/19 in Smartsheet Basics

I am using the new Multi Select Drop Down Column type, I have 2 options for check off in it. When I want to filter it in a report the check off items don't show up. I can find the column in the "What?" Section, I add it, but it will only let me filter it by "blank" not by the 2 options I have put it as check off fields in that column.  Is this possible? What am I missing?



  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are any rows populated? The report will only let you set up to pull based on data that is already in the sheet.


    When I want to set up a report based off of a brand new sheet that has no data in it, I will manually enter the data into the sheet that I want to build the report by, build the report, then delete the data from the sheet.