Report Based on Multi Select Dropdown Column


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!