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!!!

Find more posts tagged with

Formulas

Accepted answers

All comments

kchenoweth

To make this work you will need to add a column in between your First Name and Preferred Name columns. Then use this as a column formula for the newly added column:

=JOIN([Last Name]@row:[First Name]@row,", ")

Then in your desired result column use this formula:

=IF([Preferred Name]@row="",[New Column]@row,JOIN([New Column]@row:[Preferred Name]@row," "))

okm

That helps with making both names appear, but I need it all in one column and with the preferred name before the legal name. Thank you!

kchenoweth

It should look something like this.

Paul Newcome

You should be able to do it without a helper column.

=[Last Name]@row + ", " + [First Name]@row + IF([Preferred Name]@row <> "", "(" + [Preferred Name]@row + ")", "")

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.