You need to sign in to do that
Don't have an account?
Michael 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))
)
)
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))
)
)
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
Preferred phone number - should be entered ONLY when 2 or more phone numbers are entered. Any help is appreciated. TIA