Nested formulas - conditional text concatenation

I want to set up a column in which all components of a name are concatenated. However, I don't want to include the "middle initial" field if it's blank. I've achieved this in Excel, but can't seem to find the right method in Smartsheet.

A screenshot of my method in Excel:

In Smartsheet I've tried a number of variations, including:

IF([Speaker MI]7 = "", =[Speaker First Name]7 + " " + [Speaker Last Name]7 + ", " + [Speaker Degrees]7, =[Speaker First Name]7 + " " + [Speaker MI]7 + " " + [Speaker Last Name]7 + ", " + [Speaker Degrees]7 )

IF([Speaker MI]7 = "", [Speaker First Name]7 + " " + [Speaker Last Name]7 + ", " + [Speaker Degrees]7, [Speaker First Name]7 + " " + [Speaker MI]7 + " " + [Speaker Last Name]7 + ", " + [Speaker Degrees]7 )

Any suggestions? Thanks!

Find more posts tagged with

Accepted answers

All comments

Mark Cronk

Hi @Cynthia Faraday ,

Try:

IF(ISBLANK([Speaker MI]@row), [Speaker First Name]@row + " " + [Speaker Last Name]@row + ", " + [Speaker Degrees]@row, [Speaker First Name]@row + " " + [Speaker MI]@row + " " + [Speaker Last Name]@row + ", " + [Speaker Degrees]@row)

Work?

Mark

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.