Report Based on Multi Select Dropdown Column

12/30/19
Accepted

I have a master schedule that includes a multi select dropdown column for disciplines associated with each individual project. I need to create a report that shows all projects with multiple disciples selected. It needs to allow any combination of disciplines as long as there is more than one selected. Unless I'm missing something, this doesn't appear to be possible with the report builder. Is there a formula I could use to check a box in the source sheet when there are multiple disciples selected?


Any help would be appreciated. Thanks!

Best Answer

Answers

  • corygcoryg ✭✭✭✭✭

    Thanks, Andrée!

    The COUNTM Function should work just fine for now, but I did submit an Enhancement Request.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Excellent!

    Happy to help!

    Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • @coryg what did you end up doing? I am trying to do the same thing- be able to just search for one of the items in my multi-select drop down menu to add them up.

  • corygcoryg ✭✭✭✭✭

    I just added a helper column with a formula that looks like this: =COUNTM([email protected]). That gives me a number of disciplines selected for each project. I then created a report that shows all projects where the helper column has a value that is greater than 1.

    That may not be exactly what you are looking to do, but you could probably do something similar with a different function.

Sign In or Register to comment.