Nested formulas - conditional text concatenation

Cynthia Faraday

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!

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