Skip to main content
I have multi picklist. But I want to restrict 3 values to only be used exclusive. 401K Plan, Car Reinsurance, and Brokerage needs to be a single selection. If anyone tries to add one of these with another value it draws an error. Below is what I have so far but it's not working.

 

AND(

 

INCLUDES( Type__c , "401K Plan","Brokerage","Car Reinsurance"),

 

OR(

 

INCLUDES(Type__c, "Brokerage"),

 

INCLUDES(Type__c, "401K Plan"),

 

INCLUDES(Type__c, "Car Reinsurance"))
3 respostas
  1. 23 de jun. de 2020, 21:04
    OR(

     

    AND(

     

    INCLUDES( Type__c , "401K Plan"),

     

    OR(

     

    INCLUDES(Type__c, "Brokerage"),

     

    INCLUDES(Type__c, "Car Reinsurance"))),

     

    AND(

     

    INCLUDES( Type__c , "Brokerage"),

     

    OR(

     

    INCLUDES(Type__c, "401K Plan"),

     

    INCLUDES(Type__c, "Car Reinsurance"))),

     

    AND(

     

    INCLUDES( Type__c ,"Car Reinsurance"),

     

    OR(

     

    INCLUDES(Type__c, "Brokerage"),

     

    INCLUDES(Type__c, "401K Plan")))

     

    )

     

    This will help