+ Start a Discussion
Michael Sabel 9Michael Sabel 9 

Want to figure out why this Validation Rule for Preferred Phone worked on for Contacts but not Leads.

The rule should fire if at least one phone field is populated and it requires the user to select a Preferred Phone. It works on Contacts, but won't fire when a phone field is populated on Leads. I'd like to figure out why and find out what the correct formula is. Thanks.

AND(
OR(
ISNEW(),
ISCHANGED(tcf_Phone_Home__c),
ISCHANGED(MobilePhone),
ISCHANGED(tcf_Phone_Work__c)
),
NOT(ISBLANK(tcf_Phone_Home__c)),
NOT(ISBLANK(MobilePhone)),
NOT(ISBLANK(tcf_Phone_Work__c)),
NOT(ISCHANGED(npe01__Preferred_Phone__c)),
OR(
ISCHANGED(npe01__Preferred_Phone__c),
ISBLANK(TEXT(npe01__Preferred_Phone__c))
)
)
Dhanya NDhanya N
Hi Michael,

Validation rule is object specific. If you want validation rule to be fired on Lead records, then there should be seperate validation rule on Lead too. So make sure if there is a validation rule on Lead.

Thanks,
Dhanya
Nithya YogeshNithya Yogesh
Any other pointer on this solution? I have 4 phone fields, I need the preferred phone field to be a required field when more than 1 phone number is entered. 
Preferred phone number - should be entered ONLY when 2 or more phone numbers are entered. Any help is appreciated. TIA