Concatenate Name if Preferred Name not blank

Hi, I am trying to create a formula where I can concatenate a person's name as "Smith, John" if they don't have a preferred name listed (if blank) and as "Smith, Jane (John)" if they do have a preferred name.

My fields are Last Name, First Name, and Preferred Name.

Can anyone help? Thanks so much!!!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!