Formula help to JOIN results of LEFT formula down a column

Options
ritzbitz00
ritzbitz00 ✭✭
edited 02/24/23 in Formulas and Functions

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))), "; ")

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!