+ Start a Discussion
lburnslburns 

Opportunity Validation Rule Error

Hi...trying to insert an Opportunity Validation Rule where if:

 

Label Name, 'Reseller Involved' (field name - 'Reseller_Involved') is picked 'yes, then the lable name 'Reseller Name' (field name - Reseller_Name_ is to be populated/mandatory, before saving the opp.  I am using the following formula and I get this error :  Error:Syntax error. Found 'Reseller':

 

 AND  (
     OR  (
              ISPICKVAL(Reseller Involved, "Yes")),
ISNULL(Reseller_Name__c)
)

 

What is wrong with this?  Thanks in advance for your help.

CaptainObviousCaptainObvious
Change Reseller Involved to Reseller_Involved__c. When entering your formula, try using the Insert Field button to get the correct field names
Message Edited by CaptainObvious on 09-17-2009 09:48 AM
lburnslburns

Thank you.  Now I'm getting: Error: Syntax error. Missing ')'

 

AND  (
     OR  (
              ISPICKVAL( Reseller_Contact__c , "Yes"),
ISNULL(Reseller_Name__c)
)

 

 

Is this the correct formula for what I'm trying to do?

CaptainObviousCaptainObvious

It looks like you have an extra OR in your rule.

 

Try this:

 

AND( ISPICKVAL(Reseller_Involved__c,"Yes"), ISNULL(Reseller_Name__c) )

 

If Reseller Name is a text field, use this instead:

 

AND( ISPICKVAL(Reseller_Involved__c,"Yes"), LEN(Reseller_Name__c)=0 )

 

 

lburnslburns
Please ignore my last post.  I figured out the paranthesis issue, and the validation rule saved just fine, however, when I go and create my opportunity to test it out, it makes me enter the Reseller Name and when I do, it NOW wont' let me save it.  I have entered a correct Account Reseller Name!
lburnslburns
The Text formula works!  Thank you very much.