Skip to main content

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?
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.


Reply