Skip to main content
Topics#Sales And MarketingPergunta de Jenny Hill
Jenny Hill (LogMeIn) perguntou em #Sales And Marketing
28 de jan. de 2019, 15:09

validation rule exclude picklist value

Have this VR where I am trying to excude a picklist value but am getting the error "Error: Syntax error. Extra ',' "

 

AND(

 

    ISNEW(),

 

                NOT(ISPICKVAL(Category__c="Compensation Plan/Quota Inquiry")),

 

                NOT(ISPICKVAL (Sub_category__c = "Quota"))),

 

    OR(

 

       ISBLANK(Account__c),

 

       ISBLANK(Object_Origination__c)

 

       )

 

)
2 respostas
  1. Narender Singh (-)
    28 de jan. de 2019, 15:11

    Try this:

    AND(
        ISNEW(),
        NOT(ISPICKVAL(Category__c,"Compensation Plan/Quota Inquiry")),
        NOT(ISPICKVAL(Sub_category__c,"Quota")),
        OR(
           ISBLANK(Account__c),
           ISBLANK(Object_Origination__c)
           )
    )

     

     
Escrever uma resposta...
0/9000