+ Start a Discussion
NNRNNR 

Validation Rule on Picklist

Hi Fnds.. plz help me out this

  Q:: I have picklist(product_type__c) having Lov's of(type1,type2,type3,type4),i have another field like description__c(text).
   when i select the type1,descripton is not mandatory,but when i select otherthan type1,description is mandatory filed when click on save button it show msg like description is mandatroy


 
Best Answer chosen by NNR
PratikPratik (Salesforce Developers) 
Hi NNR,

Try this:

AND( NOT (ISPICKVAL(product_type__c, 'type1')), ISBLANK(description__c) )


Thanks,
Pratik

 

All Answers

PratikPratik (Salesforce Developers) 
Hi NNR,

Try this:

AND( NOT (ISPICKVAL(product_type__c, 'type1')), ISBLANK(description__c) )


Thanks,
Pratik

 
This was selected as the best answer
PratikPratik (Salesforce Developers) 
Glad it helped!

Thanks,
Pratik