Skip to main content
Hi Team,

 

I am trying to set validation rule opportunity product with the following condition:

 

*Criteria:*

 

If the Account Number is equal to X and Account's Business Unit

 

equal to "X"

 

And the following is null or blank

 

 - Po Line

 

 - Customer Product Code

 

I have tried to set it but i am getting an error:

 

IF(

 

AND(

 

(AND(AccountNumber__c  ='MTL00105')), (($Label.BusinessUnit ='Chile')),

 

((AND (OR(ISNULL (Customer_Product_Code__c)), ((ISBLANK (Customer_Product_Code__c))),

 

(OR(ISNULL (Po_Line__c)), (ISBLANK (Po_Line__c))))

 

If something missing there or any condition?

 

Regards

 

Eduardo
8 respuestas
  1. 18 oct 2017, 19:21
    Can you try removing the IF() brackets? Otherwise you need to put in 3 IF(Condition, action 1, action 2)
0/9000