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
VestaGMSVestaGMS 

Validation Formula Help

I am trying to create a validation formula that basically does the following.

 

If program type picklist = sampling, then sampling type picklist is required.

 

Any help would be greatly appreciated.

 

Thanks!!

Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/

Here you go

 

 

AND( ISPICKVAL(Picklist_Field_1, "Picklist Value"), ( ISPICKVAL(Picklist_Field_2, "")))
 
 So you'd need something like
AND( ISPICKVAL(Program_Type__c, "Sampling"), ( ISPICKVAL(Sampling_Type__c, "")))
 Double check your API Field Names and Picklist Vales (they have to match EXACTLY)
 


All Answers
Steve :-/Steve :-/
Here you go
 
 
AND( ISPICKVAL(Picklist_Field_1, "Picklist Value"), ( ISPICKVAL(Picklist_Field_2, "")))
 
 So you'd need something like
AND( ISPICKVAL(Program_Type__c, "Sampling"), ( ISPICKVAL(Sampling_Type__c, "")))
 Double check your API Field Names and Picklist Vales (they have to match EXACTLY)
 
This was selected as the best answer
VestaGMSVestaGMS
Thank you so much it worked perfectly!!


Steve :-/Steve :-/
No problem, you owe me a beer http://www.russianriverbrewing.com/web/brews/plinytheelder.html
 
 
S:-/ 
 
http://www.youtube.com/watch?v=VtVFcJiqHSQ