+ Start a Discussion
VijaykumarVijaykumar 

Validation rule: Interested Partner Program = Reseller then able to select Product Group picklists "Innovyze" or "Not Applicable"

Hi Guys, need your help on creating validation rule for below

Interested Partner Program = Reseller then able to select Product Group picklists "Innovyze" or "Not Applicable"

i have tried below but its not working!!!

ISPICKVAL(Interested_Partner_Program__c, 'Reseller') &&
ISPICKVAL(Product_Group__c,'Innovyze') || ISPICKVAL(Product_Group__c,'Not Applicable')

CharuDuttCharuDutt
Hii VijayKumar
Try Below validation
AND(
NOT(ISPICKVAL(Interested_Partner_Program__c,'Reseller')),
OR(ISPICKVAL(Product_Group__c,'Innovyze'),ISPICKVAL(Product_Group__c,'Not Applicable'))
) 
Please Mark It As Best Answer If It Heps
Thank You!
VijaykumarVijaykumar
Hi Charu, Thank you so much for the swift action but still other picklist values are also showing [image: image.png] Thanks & Regards, *Vijaykumar K L*
CharuDuttCharuDutt
Please Close Your Query By Marking It As Best Answer If It Helps
Thank You!
VijaykumarVijaykumar
Hi Charu, I have tried this, but still its not working as per the expectation. PFA for reference. AND( NOT(ISPICKVAL(Interested_Partner_Program__c,'Reseller')), OR(ISPICKVAL(Product_Group__c,'Innovyze'),ISPICKVAL(Product_Group__c,'Not Applicable')) ) Thanks & Regards, *Vijaykumar K L*
AnkaiahAnkaiah (Salesforce Developers) 
Hi Vijay,

Try with below .
 
AND( Text(Interested_Partner_Program__c)='Reseller', 
OR(Text(Product_Group__c)<>'Innovyze',
   Text(Product_Group__c)<>'Not Applicable'))

If this helps, Please mark it as best answer.

Thanks!!