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)

October 11, 2016
·
Like
0
·
Follow
1

Best Answer chosen by Ben Kingsley 8

Urvik
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%")))

October 11, 2016
·
Like
0
·
Dislike
0

This was selected as the best answer

Ben Kingsley 8
Thanks Urvik.....This works as intended.

October 11, 2016
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Need Help with Validation Rule

All Answers

You need to sign in to do that.