+ Start a Discussion
Synthia BeauvaisSynthia Beauvais 

Validation rule on Picklist

If there is a description in text field X3PL_Customer_Owned_Items_Description__c
picklist X3PL_Customer_Owned_Items__c must contain "Informational Only" or "Review Required"​

I am getting Error: Syntax error. Extra ','
 
AND(
NOT(ISPICKVAL(X3PL_Customer_Owned_Items__c, 'Informational Only')),
NOT(ISPICKVAL(X3PL_Customer_Owned_Items__c, 'Review Required')),
NOT(ISBLANK(X3PL_Customer_Owned_Items_Description__c))
),
AND(      
NOT(ISPICKVAL(X3PL_Veritiv_Provided__c, 'Informational Only')),
NOT(ISPICKVAL(X3PL_Veritiv_Provided__c, 'Review Required')), 
NOT(ISPICKVAL(X3PL_Veritiv_Provided_Description__c))
))

Thanks in advance! 
 
Best Answer chosen by Synthia Beauvais
veda Hebbarveda Hebbar
Hi Synthia,
 
OR(
	AND(  
		NOT(ISBLANK( X3PL_Customer_Owned_Items_Description__c )),
		OR( 
			NOT(ISPICKVAL( X3PL_Customer_Owned_Items__c , 'Informational Only')),
			NOT(ISPICKVAL( X3PL_Customer_Owned_Items__c , 'Review Required')) 
		)
	), 
	AND(  
		NOT(ISBLANK( X3PL_Veritiv_Provided_Description__c )),
		OR( 
			NOT(ISPICKVAL( X3PL_Veritiv_Provided__c , 'Informational Only')),
			NOT(ISPICKVAL( X3PL_Veritiv_Provided__c , 'Review Required')) 
		)
	) 
)

Please check this.
Thanks,
Vedashri

All Answers

veda Hebbarveda Hebbar
Hi Synthia,
 
OR(
	AND(  
		NOT(ISBLANK( X3PL_Customer_Owned_Items_Description__c )),
		OR( 
			NOT(ISPICKVAL( X3PL_Customer_Owned_Items__c , 'Informational Only')),
			NOT(ISPICKVAL( X3PL_Customer_Owned_Items__c , 'Review Required')) 
		)
	), 
	AND(  
		NOT(ISBLANK( X3PL_Veritiv_Provided_Description__c )),
		OR( 
			NOT(ISPICKVAL( X3PL_Veritiv_Provided__c , 'Informational Only')),
			NOT(ISPICKVAL( X3PL_Veritiv_Provided__c , 'Review Required')) 
		)
	) 
)

Please check this.
Thanks,
Vedashri
This was selected as the best answer
veda Hebbarveda Hebbar
Hi Synthia,

Are you able to solve the issue? Please let me know if you need more information or help on this.

Thanks,
Vedashri