I often encourage the nonprofits I work with to avoid using multi-select picklists, and I always get the same question back: Why? Here are a two of my many reasons why I personally advise against using multi-select picklists whenever possible, why do you use or not use them?
1. They are really difficult to work with in formulas. Example: I wanted to use values from a multi-select picklist field as part of a naming convention for cases. There's not an easy way to do this. In fact, Salesforce help points out there are very few formulas where multi-select picklists can be used. Here they are:
2. They are hard to work with in reporting. Example: I wanted to use race as a multi-select picklist field to allow people to self identify in whatever way they choose. This is great, until I realized that to accurately capture people and that myriad ways to self-identify, I'd have to create a report for each picklist value (e.g., African American, Asian, Latinx, etc.) and then people would be double counted across the reports (e.g., someone who multi-selected African American and Latinx). I would then also need to create reports with all of the possible permutations or report on each person individually to allow for their full individual expression. Instead, I opted to use checkboxes which make reporting much more clear. Also, to be clear, to be able to report on one option in a multi-select picklist requires a super annoying workaround! Ugh! Read how to do that here. How this makes me feel:
So, what are your thoughts? Are there times when you don't need to report on multi-select picklists so you just use them anyways? Are there times when you've used one only to realize later you would have preferred checkboxes? Let me know!
Missy (@missylongshore on Twitter and Periscope) writes this blog just for you!