+ 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 MolisSteve Molis

You could also use a VR like this:

 

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