I'm hoping someone on here will be able to help me troubleshoot a formula construction for a validation rule I'm trying to implement on our Opportunity object.
Essentially I want the validation rule to fire if a user tries to save an opportunity record that they have indicated has had SDR involvement, but they haven't completed the 'Sales Development Rep' field.
The first picklist field I want to check against is one called 'Inbound vs Self Generated'. There are two picklist values I'm wanting to evaluate here. These are:
'SDR Generated' and 'SDR/BDM Collaboration'.
User should not be able to save record if any of these values are present, and the second picklist 'Sales Development Rep' is blank.
I have tried several different constructions, but I cannot find a way to evaluate both picklist values from the 'Inbound vs Self Generated' picklist. Here's what I've tried:
OR( ISPICKVAL( Inbound_vs_Self_Generated__c , "SDR Generated") , ( ISPICKVAL( Inbound_vs_Self_Generated__c , "SDR/BDM Collaboration")), AND( ISPICKVAL( Sales_Development_Rep__c, "" )))
The above doesn't give me a syntax error, but when I try to test it, its throwing the validation error on all the picklist values, and not only the two I want it to.
Can someone help please? I've built a formula to evaluate one value only and that works fine. See below:
AND( ISPICKVAL( Inbound_vs_Self_Generated__c , "SDR Generated") , ISPICKVAL( Sales_Development_Rep__c , ""))
That one works fine - I can't work out how to replicate this so that it can evaluate my second picklist value as well.