Formula help to JOIN results of LEFT formula down a column
I have a column of values, I'd like to use a Join function to combine all the values into a list, but first i'd like each of these values to be trimmed via the left function. Here is an example of the Left function I am using:
=LEFT([ColumnName]1, FIND(CHAR(10), [ColumnName]1))
How do I integrate this into a JOIN operation so that I get my desired result? I understand I could use a helper column to first do the LEFT operation and then run JOIN on that column but I'd prefer to avoid that if possible. I have no issue with a large dense formula. Below is a working formula for a single cell vs a whole column
=JOIN(DISTINCT(LEFT([ColumnName]1, FIND(CHAR(10), [ColumnName]1))), "; ")
Answers

You would need to use the helper column.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!