Skip to main content
Topics#Data ManagementDanielle Harrison's Question
Danielle Harrison (AllCloud) asked in #Data Management
Dec 18, 2018, 4:25 PM

Hello, I am trying to create a validation rule on a picklist field and receiving the Error: Syntax error. Missing ') message.

Hello, I am trying to create a validation rule on a picklist field and receiving the  Error: Syntax error. Missing ')  message. My formula is:

 

IF ( INCLUDES ( parent.multipicklist__c , "EZ Pay"), EZ_Pay_Payments__c = 0 OR EZPay_Start_Date__c == null OR EZ_Pay_Down_Payment__c = 0 ELSE IF (EZ_Pay_Down_Payment__c >= Min_EZ_Pay_Down_Payment__c) AND (EZ_Pay_Payments__c <= Max_EZ_Pay_Payments__c)
6 answers
  1. Edward Scott (Measured Results Marketing)
    Dec 18, 2018, 5:24 PM
    Hi Danielle I think you are missing a ) at the very end. I wish we could use colors on here but let's try this. 

     

    IF *( INCLUDES $( parent.multipicklist__c , "EZ Pay")$, EZ_Pay_Payments__c = 0 OR EZPay_Start_Date__c == null OR EZ_Pay_Down_Payment__c = 0 ELSE IF &(EZ_Pay_Down_Payment__c >= Min_EZ_Pay_Down_Payment__c) &AND #(EZ_Pay_Payments__c <= Max_EZ_Pay_Payments__c)# 

     

    The open and close symbols match for everything except the *. So I think you just need one at the end.
Write an answer...
0/9000