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!
Answers
-
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
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!