function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Balu Phrabha123Balu Phrabha123 

validation rule on multipicklist values

HI I am having three picklist values.
A. Stage, B. Spend Margin, C.New Account.
Both Spend Margin and New Account are picklist values.
Picklist values for Spend Margin : Master Card & Visa Card
Picklist Values for New Account: Amex & Chase

If the stage is Close out the two picklist field values should have some picklist values in it.

Thanks for the responce.

 

Sagar PatilSagar Patil
Hi Azad,

Try this,
  
AND( 
        Text(API_NAME_OF_STAGE_FIELD) ='API_NAME_OF_CLOSE_out', 
        OR( 
               ISBLANK(TEXT(API_NAME_OF_SPEND_MARGIN_FIELD)), 
               ISBLANK(TEXT(API_NAME_OF_NEW_ACCOUNT_FIELD)) 
             ) 
    )

Kindly mark this as a best answer if it helps you.

Regards,
Sagar 
kamala swarnalathakamala swarnalatha
Hi,

Try this one

AND(ISPICKVAL( Stage__c , "Close out"),ISPICKVAL( Spend_margin__c , ""),ISPICKVAL( New_account__c , "")) || 
AND(ISPICKVAL( Stage__c , "Close out"),ISPICKVAL( Spend_margin__c , "")) || 
AND(ISPICKVAL( Stage__c , "Close out"),ISPICKVAL( New_account__c , ""))

Kindly mark this as a best answer if it helps you.

Thanks,
Kamala
Sweet Potato Tec