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
markoulakismarkoulakis 

Validation rule help

I need to create a validation rule for when a picklist value is NOT blank, then an email address field must be required.

 

I have a field called "Special Request Approval" which is a dependent picklist field off of a field called "Approval Region".  The Approval Region is already a required field on the page layout.  Depending on the region chosen, the Special Request field will return the names of the managers for that region in the picklist.  If the Special Request Approval picklist is NOT blank, then I need to make the "Special Request Approval Email" address required.

 

Any help would be greatly appriciated.

 

Thanks!

Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/

Here you go

 

AND(
NOT(ISBLANK(TEXT(PicklistFiledName))),
ISBLANK(EmailFieldName))

 

All Answers

Steve :-/Steve :-/

Here you go

 

AND(
NOT(ISBLANK(TEXT(PicklistFiledName))),
ISBLANK(EmailFieldName))

 

This was selected as the best answer
markoulakismarkoulakis

Thanks Steve!!  I knew you would respond to this request.  You ROCK!

 

Best,

Marie
mluisimluisi
This tip from 2012 lives on in infamy. It helped me today in 2022! Does that mean I owe 10x the number of beers?