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

[tahsinh]

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?

[Dan_Montoya]

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.