You need to sign in to do that
Don't have an account?
Nithya Yogesh
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
preferred phone number field Validation Rule
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
I did not clarity for 2nd as it seems contradicting with first .
Thanks!
Try this below :-
Here, Phone1 & Phone2 are the two other numbers.
If this helps, please mark it as best answer.
Regards,
Priya Ranjan
Please follow below formula:
if you need any assistanse, Please let me know!!
Kindly mark my solution as the best answer if it helps you.
Thanks
Mukesh
4 number fields - phone numbers
1 picklist field - preferred phone number (has the options of all 4 Phone numbers)
Seems like a vague, too long formula to check for each combination of phone number and then select one of the numbers as Preferred.