0

I am trying to create a validation rule that has multiple sets of criteria, one of them being preventing the LeadSource picklist field from being blank. Below is my formula which for some reason still lets the record save even though the Lead Source picklist field is blank.

The goal of the validation rule is to run and validate:

  • RecordType = "Management"
  • Lead Status enters "Targeted" status
  • Lead Source is Blank
  • At Least Phone Number OR Email must be filled out.
AND( $RecordType.DeveloperName = "Management", ISPICKVAL(Status,"Targeted"), ISPICKVAL(LeadSource,""), OR( AND( ISBLANK(Email), ISBLANK(Phone) ) ) )
Improve this question
1
  • I would try something like this: NOT(ISBLANK(TEXT(LeadSource))). Commented Sep 5, 2019 at 16:32

1 Answer 1

Reset to default
0

This update to the validation rule resolved my issue. This works by ensuring LeadSource is filled out and either the Email or Phone field has a value.

AND( $RecordType.DeveloperName = "Management", ISPICKVAL(Status,"Targeted"), OR( ISBLANK(TEXT(LeadSource)), AND( ISBLANK(Email), ISBLANK(Phone) ) ) )
Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.