function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Ben Kingsley 8Ben Kingsley 8 

Need Help with Validation Rule

Hello everyone,

I am tryign to use this validation rule and getting some errors.  Can someone please help me.

ISPICKVAL(Specific_Product_Type__c, "Trust Services")&& RecordType.Name="Investments/Insurance - BCIS"  OR(
ISPICKVAL(Probability__c,"50%",ISPICKVAL(Probability__c,"75%"),ISPICKVAL(Probability__c,"100%")) 
&& ISBLANK(Specialty_Partner__c)
Best Answer chosen by Ben Kingsley 8
UrvikUrvik
Give this a try...

AND(
ISPICKVAL(Specific_Product_Type__c, "Trust Services"),
RecordType.Name="Investments/Insurance - BCIS",
ISBLANK(Specialty_Partner__c),
OR(
ISPICKVAL(Probability__c,"50%"),
ISPICKVAL(Probability__c,"75%"),
ISPICKVAL(Probability__c,"100%")))

 

All Answers

UrvikUrvik
Give this a try...

AND(
ISPICKVAL(Specific_Product_Type__c, "Trust Services"),
RecordType.Name="Investments/Insurance - BCIS",
ISBLANK(Specialty_Partner__c),
OR(
ISPICKVAL(Probability__c,"50%"),
ISPICKVAL(Probability__c,"75%"),
ISPICKVAL(Probability__c,"100%")))

 
This was selected as the best answer
Ben Kingsley 8Ben Kingsley 8
Thanks Urvik.....This works as intended.