I'm working on creating a validation rule where I have:
- Multi-Select-Picklist (
- Text field (
The rule is: If the user selects
Other from multi-select pick list then
other_explanation__c is required to enter.
I have attempted to do something like this:
AND(ISPICKVAL(Status, 'Career Advisor - Inbound'), AND(ISPICKVAL(multi_select_picklist__c != 'Other')), ISBLANK(other_explanation__c) OR( $Profile.Name == "Administrator", $Profile.Name =="Super User" ) )