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
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)