Validation rule: No_Business_Phone

Name

No_Business_Phone

Label

No_Business_Phone

Object

Contact

Active

No

Formula

AND(
ISPICKVAL(AQB__PhonePreference__c ,"Business Phone"),
LEN(AQB__BusinessPhone__c)=0
)

Error message

You have selected 'Business Phone' as the 'Phone Preference', but the 'Business Phone' field is blank. Please enter and save a 'Business Phone' on the 'Primary Employment' before changing the 'Phone Preference' or select a different 'Phone Preference'.

Error location

Phone Preference