Skip to main content
Topics#FormulasOdell Dair's Question
Odell Dair asked in #Formulas
Jul 7, 2016, 4:24 PM

Picklist (Multi-Select) Validation Rule

I'm seeking a validation rule that will make a Picklist selection from a (Multi-Select) Picklist, enforce the completion of another (Multi-Select) Picklist ?

 

Picklist (Multi-Select) API Name:

Capita_entity_departments__c

Picklist (Multi-Select) list values:

Actuarial, Investment & DB Consulting

Business Operations

Business Solutions

Employee Benefits & Reward

Pensions Management

 

Additional Picklist (Multi-Select) API Names: 

AIDB_Services__c

Business_Operations_Services__c

Business_Solutions_Services__c

Employee_Benefits_and_Reward_Services__c

Pensions_management_Services__c

 

So for example, if the User selected  "Actuarial, Investment & DB Consulting" in the first (Multi-Select) Picklist (Capita_entity_departments__c), they would be required to complete the AIDB_Services__c (Multi-Select) Picklist.

 

Thank you so much 
2 answers
  1. Maharajan Chinnadurai (Infosys Limited)
    Jul 9, 2016, 7:47 AM
    Hi Odell,

    Use the below formula in your validation rule to attain your requirement : 

    IF( INCLUDES(Capita_entity_departments__c,'Actuarial, Investment & DB Consulting') , ISBLANK( AIDB_Services__c),null)

    Then give a proper error message in your VR.

    Let me know if you want any further help...

    If the formula help means mark these as a best answer...

    Thanks,

    Raj

    (Sweet Potato Tec)
Write an answer...
0/9000