Photo by Agence Olloweb on Unsplash
Today I learned why people complain about multi-select picklists—and I will probably avoid them forever now.
I created one thinking it would give users flexibility. But now I’m realizing:
You can’t use multi-selects in many report filters
They’re annoying to work with in Flows and formulas
You have to use INCLUDES() instead of simple = logic
It’s not that they’re useless—they just come with baggage. Next time, I’ll consider using a custom object with checkboxes or just a regular picklist with well-defined values.
Lesson learned: flexibility ≠ better.
