function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

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



Try this in your formula

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






Create the Field dependency between these two picklist fields.

And Make Dependent field as required from the pagelayout.



Srikanth. K

Steve :-/Steve :-/

You could also use a VR like this:


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 (" 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.


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 (