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
KACCENTKACCENT 

Lead Validation Rule - Other Lead Source? - should be pretty easy!

Hello!  Can someone please help me with the following validation rule?

 

If the lead source equals either of the following choices, I would like the user to have to identify the specific source "other" source.  

 

AND(ISPICKVAL(LeadSource, "Other" ), ISPICKVAL(LeadSource, "Business Development Relationship" ) , ISPICKVAL(LeadSource, "Partner" ) ,Lead_Source_Other_Partner__c = " " ) 

 

Thanks for any help you can provide - I know I'm missing one tiny thing somewhere, but I have given up; I can't figure it out! 

Message Edited by KACCENT on 03-16-2009 07:44 AM
Message Edited by KACCENT on 03-16-2009 07:45 AM
Message Edited by KACCENT on 03-16-2009 07:46 AM
Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/
Give this a shot
AND (
  OR (
     	ISPICKVAL(LeadSource, "Other"),
	ISPICKVAL(LeadSource, "Partner"),
     	ISPICKVAL(LeadSource, "Business Development Relationship")),
LEN(Lead_Source_Other_Partner__c)=0 )
 


All Answers
Steve :-/Steve :-/
Give this a shot
AND (
  OR (
     	ISPICKVAL(LeadSource, "Other"),
	ISPICKVAL(LeadSource, "Partner"),
     	ISPICKVAL(LeadSource, "Business Development Relationship")),
LEN(Lead_Source_Other_Partner__c)=0 )
 
This was selected as the best answer
KACCENTKACCENT
Thanks very much, Stevemo!  I really appreciate it!!!!!!