JOIN IF formula help!
I'm looking to Join 2 contact columns into 1 text column* with something to space the 2 values out so the names in the formula column do not run together w/out spaces.
The problem with this is that if there is a missing value in 1 or both reference columns, the character I'm using to space ("  ") appears for no reason.
IMAGE OF ISSUE BELOW: The first row is appearing correctly, but all rows beneath are displaying my problem.
FORMULA CURRENTLY IN USE: =[Neo Exec]@row + "  " + [Neo Coordinator]@row
I think I need to incorporate an "IF" statement so that the spacing character does not appear unless it is needed (i.e., unless there is a value in BOTH columns, not just 1 column, and definitely not if both columns are blank!), but I haven't been able to crack exactly how to phrase it (my formula work/knowledge is limited, as you can see).
THANK YOU in advance, for any help/tips/suggestions!!!
LK
(*I'm applying this formula to a text column as I do not believe it's possible to make a contact column a formula column, but if anyone knows of a workaround to make that a reality, I would be anxious to hear it!)
Best Answer

NEVERMIND! I figured out a workaround using "CHAR(10))"
:)
Answers

NEVERMIND! I figured out a workaround using "CHAR(10))"
:)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!