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