Skip to main content
Topics#EmailSophie Ritzman の質問
Sophie Ritzman (Cloudbase) が「#Email」で質問
2014年4月2日 11:17

Need help with formula for addressing more than one contact

I have 2 related contacts (Contact1 & Contact2).  

 

If Contact1 LastName = Contact2 LastName,

 

then "Contact1 FirstName & Contact2 FirstName",

 

else

 

Contact1 FirstName Contact1 LastName

 

& Contact2 FirstName Contact2 LastName
10 件の回答
  1. Christoph Eschweiler (SUNZINET GmbH)
    2014年4月2日 12:34
    Hi Sophie,

     

    In that case, try this formula:

     

    IF(ISBLANK(Contact2.FirstName) || ISBLANK(Contact2.LastName), Contact1.FirstName + ' ' + Contact1.LastName, IF(Contact1.LastName == Contact2.LastName, Contact1.FirstName + ' & ' + Contact2.FirstName, Contact1.FirstName + ' ' + Contact1.LastName + ' & ' + Contact2.FirstName + ' ' + Contact2.LastName))

     

    Best Regards,

     

    Chris
回答を記入...
0/9000