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
EHavenEHaven 

Help with Validation Rule: Make picklist selection required when Stage moves to "Bell"

I am trying to create a validation rule that will require users to select a value from the picklist "Revenue Type" whenever the opportunity stage changes to "Bell". I am having trouble making this work correctly. Here is my current attempt at a validation rule:

 

AND( ISPICKVAL( StageName, "Bell"),   ISPICKVAL( Revenue_Type__c, "0"))

 

(but this doesn't seem to work since I can still change an opportunity to the "Bell" stage without having to select a Revenue type before saving).

 

Any help would be much appreciated!!

NPMNPM
AND( ISPICKVAL( StageName, "Bell"),ISNULL( Revenue_Type__c))


 
 
 


Dan_LichtmanDan_Lichtman
If Revenue_Type__c is a picklist field, the function will not work, change it to
AND( ISPICKVAL( StageName, "Bell"),ISPICKVAL( Revenue_Type__c,""))


 
 
 
 


NPMNPM
Absolutely right - blew right by me.  Nice pickup Dan.


EHavenEHaven
Thank you so much!! That worked perfectly. I really appreciate the help.