Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula If client is married, primary field will show spouses name.

Topic Labels: Community Data Formulas
889 1
cancel
Showing results for 
Search instead for 
Did you mean: 
tahsinh
4 - Data Explorer
4 - Data Explorer

I have the primary field set as a formula right now as 

CONCATENATE({Client Last Name},', ', {Client First Name}). I want the formula to include the spouses name after the client's name if the marital status (separate field) is married. What would be the formula for the primary field if I wanted it to be Client Last Name, Client First Name & Spouse First Name Spouse Last Name if the marital status field is married?
1 Reply 1
Dan_Montoya
Community Manager
Community Manager
IF({IsMarried}, 
     CONCATENATE({Client Last Name},', ', 
                 {Client First Name}, ', ', 
                 {Spouse Last Name},', ', 
                 {Spouse First Name}),
 CONCATENATE({Client Last Name},', ', {Client First Name}))

It would look something like this.