I've worked on a client's #Salesforce org where the Case object had 10s of picklists.
I've ran queries on their case records and, out of thousands, only very few records had values in those picklists.
Those picklists were either:
- some information that belonged in the account, for example, whether the case was from a government, non-profit or commercial entity
- multi-select picklists
- picklists with way too many options, too granular
- dependent picklists
- nature of the inquiry - something that maybe required a person to think too much when categorizing the case
- unrestricted picklists - for example, users entered case priority as numbers instead of simply selecting Low, Medium, High
Some ideas to remediate this are:
1) implement case creation with very few fields, fewer options, avoid decision fatigue
2) implement case creation via a wizard
3) have some other way of categorizing the cases via natural language processing (Einstein Case Classification or Einstein Language API)
Any other ideas to solve this?