Skip to main content
I'm having trouble writing a validation rule that requires a user to pick multiple items from a multi-select picklist. 

 

Below are the requirements, let me know if this is even possible. 

 

Field Name: Account_Types_c

 

Picklist Values: Item A, Item B, Item C, Item D

 

If user picks Item A nothing happens.

 

If user picks Item B, they must also select Item A.

 

If user picks Item C, they must also select Item B and Item A.

 

If user picks Item D, they must also select Item C, Item B and Item A.

 

Is this even possible or do you not recommend using a picklist? 

 

Thank you inadvance for all of your help Salesforce Community!
5 answers
  1. Jul 15, 2015, 10:04 PM

    I would use checkboxes.  This allows you to still control for different validations - but you could also use Workflow Rules to automatically set the subsequent checkbox fields when the 'main one' was selected (a much better user experience if a Rep forgets to check one).

    And, you can also then easily report on Number of A, Number of B, Number of C.

0/9000