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
kmurphy.ax1526kmurphy.ax1526 

Validation rule to make picklist mandatory if certain value in another picklist field is selected

I have a picklist field called "Line of Business" and if the picklist value selected by the user equals "Hotel Direct" then I want another picklist field "Property Type" to become mandatory.

 

Thanks for the help!!
Kate
@anilbathula@@anilbathula@

Hi

 

Try this in your formula

AND(ISPickval( Line_of_business__c ,'Hotel direct'),Ispickval( property_type__c ,''))

 

 
skodisanaskodisana

Hi,

 

Create the Field dependency between these two picklist fields.

And Make Dependent field as required from the pagelayout.

 

Thanks,

Srikanth. K
Steve :-/Steve :-/

You could also use a VR like this:

 

AND(
TEXT( Line_of_business__c ) = "Hotel direct",
ISBLANK(TEXT( property_type__c)))

 
ciyov kevinciyov kevin
In this article, you will find the whole process to complete the home depot survey and become eligible to win sweepstakes of a $5000 gift card. www homedepot com survey (https://takesurvey.onl/www-homedepot-com-survey/" target="_blank)
Arun Kumar 1141Arun Kumar 1141

Hi kmurphy.ax1526,
 
Please try this validation code:
AND( ISPICKVAL(Line_of_Business__c, "Hotel Direct"), ISBLANK(TEXT(Property_Type__c)) )

Hope this helps.

Thanks!
Sheila HopkinsSheila Hopkins
You have a great website! We will help your website rank up with our complete link building service. We have calculate for the effect of each methods and if merger all methods in one with a right time for diversification of backlink, it will give us one big effect for SEO solution.

Read on: Buy complete link building (https://good-backlink.com/complete-link-building-service.html)