+ Start a Discussion
RobKretzRobKretz 

Validation Rule - Picklist Values

Hola, 

 

Seeking help with a validation rule I want to put in place. 

 

I have 2 picklists. 

 

First picklist is Stage Name, "Negotiation/Review"

Second picklist is called   "User_Buyer_s_Degree_of_Influence__c"

 

Basically what I'm looking for is.. 

 

If the stagename, Negotiation/Review is selected, and the User Buyers Degree of Influence is not selected, the save is blocked. 

 

 

I get the ISPICKVAL can be used for the Stage Name, but I get an error if i use ISPICKVAL for the User buyer... 

 

Thanks in advance!!!!! 

 

-Rob 

 

Best Answer chosen by Admin (Salesforce Developers) 
Madhan Raja MMadhan Raja M

Hi Rob,

 

Try this Formula:

 

AND(ISPICKVAL(stagename, 'Negotiation/Review'), ISPICKVAL(User_Buyer_s_Degree_of_Influence__c,''))

@Harsha: We cannot use Null for a Picklist field.

 

Madhan Raja M

All Answers

harsha__charsha__c

Hi

 

Try this one..!

 

AND(ISPICKVAL(stagename, 'Negotiation/Review'), ISPICKVAL(User_Buyer_s_Degree_of_Influence__c, '')

 

 

 

If this makes your solution, mark it as a solution for other's reference..!

 

Thanks

Madhan Raja MMadhan Raja M

Hi Rob,

 

Try this Formula:

 

AND(ISPICKVAL(stagename, 'Negotiation/Review'), ISPICKVAL(User_Buyer_s_Degree_of_Influence__c,''))

@Harsha: We cannot use Null for a Picklist field.

 

Madhan Raja M

This was selected as the best answer
harsha__charsha__c

Ohhh

 

Thanks Madhan 

 

I forgot that the User_Buyer_s_Degree_of_Influence__c, is also a picklist..!

 

Now I editted it to proper..!

Madhan Raja MMadhan Raja M

You are welcome, Hasha!

 

Madhan Raja M

RobKretzRobKretz

Thank you BOTH very much for your help. 

 

I really appreciate it. 

 

Have a good one guys. 

 

Take care. 

sruthiforcesruthiforce

validation rule

 

Make the Reverse Bingo fields required on closing a case if:
(1) Account_Authorization__c contains RASP
(2) Account.Type = SI, System Integrator, Service Provider
(3) Type <> Support Site Admin, License request

((1) OR (2)) AND (3)