Skip to main content
Topics#Data ManagementCaylee Clark's Question
Caylee Clark (Truist Bank) asked in #Data Management
Jan 22, 2020, 3:24 PM

Specify a Preferred Phone Number in formula field

We have a formula field to roll up a selected preferred phone number to the highlight bar (we're in LEX) - it's only rolling up the numbers if 'Mobile Phone' is selected. I need to add 'Home Phone' and 'Business Phone', however I get an error of 'missing ')'' when I try to update. Below is the current formula, how can I add business and home?:

 

CASE(TEXT(Primary_Number__c) ,

 

'Business Phone', PersonContact.Phone ,

 

'Home Phone',PersonContact.HomePhone ,

 

'Mobile',

 

"("&LEFT(PersonContact.MobilePhone,3)&") "&

 

LEFT(RIGHT(PersonContact.MobilePhone,7),3)

 

&"-"&RIGHT(PersonContact.MobilePhone,4)

 

,

 

NULL)
2 answers
  1. Ankush Dureja (NJC Labs)
    Jan 22, 2020, 3:37 PM

    Can you please try this

    CASE(TEXT(Primary_Number__c),
        'Business Phone', PersonContact.Phone,
        "(" & LEFT(PersonContact.Phone, 3) & ") " &
        LEFT(RIGHT(PersonContact.Phone, 7), 3)
        &
        "-" & RIGHT(PersonContact.Phone, 4),
        'Home Phone',
        "(" & LEFT(PersonContact.HomePhone , 3) & ") " &
        LEFT(RIGHT(PersonContact.HomePhone , 7), 3)
        &
        "-" & RIGHT(PersonContact.HomePhone , 4),
        'Mobile',
        "(" & LEFT(PersonContact.MobilePhone, 3) & ") " &
        LEFT(RIGHT(PersonContact.MobilePhone, 7), 3)
        &
        "-" & RIGHT(PersonContact.MobilePhone, 4),
        NULL
    )

     

     
Write an answer...
0/9000