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.