You need to sign in to do that
Don't have an account?
lburns
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.
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?
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 )