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
Bhagyashri Jadhav 61Bhagyashri Jadhav 61 

validation rule for multiscale picklist

requirements are changed by my boss. Now we have created the multi-picklist with all the values like phone, email, and name. once we select the staus as junk or unqualified this multiscale picklist cant is blanck.
Best Answer chosen by Bhagyashri Jadhav 61
AnkaiahAnkaiah (Salesforce Developers) 
Hi Bhagyashri,

try with below code. I have missed the , 
AND(ISCHANGED(Status__c),
     OR(
ISPICKVAL(Status ,'Junk'),
ISPICKVAL(Status__c,'Unqualified')),
ISBLANK( Status_Narrative__c ))
If this helps, Please mark it as best answer.

Thanks!!
 

All Answers

Bhagyashri Jadhav 61Bhagyashri Jadhav 61
can we create a validation rule with the same logic with help of a picklist? if yes may i know how?
 
AnkaiahAnkaiah (Salesforce Developers) 
Hi Bhagyashri,

try with below code. modify the field API names as per your org.
  
AND(ISCHANGED(Status__c),
     OR(ISPICKVAL(Status__c,'junk'),ISPICKVAL(Status__c,'unqualified'))
	 ISBLANK(Picklist__c))
If this helps, Please mark it as best answer.

Thanks!!

 
Bhagyashri Jadhav 61Bhagyashri Jadhav 61
AND(ISCHANGED(Status__c),
     OR(
ISPICKVAL(Status ,'Junk'),
ISPICKVAL(Status__c,'Unqualified'))
     ISBLANK(Text( Status_Narrative__c )))

I am getting an error as " Error: Syntax error. Missing ')'"
Bhagyashri Jadhav 61Bhagyashri Jadhav 61
Please help me with above error. I really appreciate your all efforts. 
AnkaiahAnkaiah (Salesforce Developers) 
Hi Bhagyashri,

try with below code. I have missed the , 
AND(ISCHANGED(Status__c),
     OR(
ISPICKVAL(Status ,'Junk'),
ISPICKVAL(Status__c,'Unqualified')),
ISBLANK( Status_Narrative__c ))
If this helps, Please mark it as best answer.

Thanks!!
 
This was selected as the best answer