You need to sign in to do that
Don't have an account?
KimberlyJ
Can I combine multiple validation rules into one validation rule?
I have PE, and I maxed out on my active validation rule limit. I have three related validation rules that work independently, and I was wondering if I could put them together into one validation rule. I tried putting them together as is but had syntax issues.
AND( Services__c >0,( Product__c =0), ISNULL( Services_Product_Involved__c ))
AND( Support__c >0, ISNULL( Support_Vendors__c ))
AND(Product__c >0, ISPICKVAL( Product_Manufacturer__c , ""))
Any assistance will be appreciated.
Thanks.
I didn't test this on my Dev Org so #Safeharbor but how about something like this?
All Answers
I didn't test this on my Dev Org so #Safeharbor but how about something like this?
Thank you! That worked great. Now I'm trying to put in a date condition and basically I want this rule to work ONLY on opportunities created after 6/6/2012 but it looks like I'm getting an error message if I try to edit an opportunity that was created before 6/6/2012 regardless if the original validation criteria is met or not. There is no syntax error.
OR( DATEVALUE (CreatedDate) <DATE(2012,6,6),
OR(
AND(Services__c > 0,
(Product__c <1),
ISNULL(Services_Product_Involved__c)),
AND(Support__c > 0,
ISNULL(Support_Vendors__c)),
AND(Product__c > 0,
ISBLANK(TEXT(Product_Manufacturer__c)))))
Thanks.