function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Adelchi PelizzoAdelchi Pelizzo 

OR condition nested in a formula

I would like to create a validation rule to check if one specific field is checked together with others group of fields: If field A is checked and any other fields of group B or C are empty. If I use the following formula it says: a parthesis is missing. 
AND
(
	( Web_Application_Security_Checkup__c = true),
	(OR
		(OR
			(
					
				X1_Web_Application_IP__c = "",
				ISPICKVAL(X1_Technology__c , ""),
				ISPICKVAL(X1_Would_Test_Account_be_Provided__c, ""),
				(ISBLANK(Number_of_Web_Application_and_Servers__c)),
				(ISBLANK(X1_URL_of_Application__c))
			)	
		),
		(OR
			(	
				X2_Web_Application_IP__c = "",
				ISPICKVAL(X2_Technology__c , ""),
				ISPICKVAL(X2_Would_Test_Account_be_Provided__c, ""),
				(ISBLANK(Number_of_Web_Application_and_Servers__c)),
				(ISBLANK(X2_URL_of_Application__c)) 
			)	
		)	
	)
			
)

 
Best Answer chosen by Adelchi Pelizzo
Neetu_BansalNeetu_Bansal
Hi Adelchi,

Please try below one : 
AND
(
	( Web_Application_Security_Checkup__c = true),
	OR(
		(OR
			(
					
				X1_Web_Application_IP__c = "",
				ISPICKVAL(X1_Technology__c , ""),
				ISPICKVAL(X1_Would_Test_Account_be_Provided__c, ""),
				(ISBLANK(Number_of_Web_Application_and_Servers__c)),
				(ISBLANK(X1_URL_of_Application__c))
			)	
		),
		(OR
			(	
				X2_Web_Application_IP__c = "",
				ISPICKVAL(X2_Technology__c , ""),
				ISPICKVAL(X2_Would_Test_Account_be_Provided__c, ""),
				(ISBLANK(Number_of_Web_Application_and_Servers__c)),
				(ISBLANK(X2_URL_of_Application__c)) 
			)	
		)
	)		
)
Thanks,
Neetu