How do I get just the first 4 characters to the left of the text string (2700insurance)
WinaHath
✭✭✭
JOIN(COLLECT([2700 & 5090 Codes]@row:[6000 Codes]@row, [2700 & 5090 Codes]@row:[6000 Codes]@row, @cell <> ""), ", ")
I need to get the first 4 numbers to the Left of the text string from each of the columns and output to another column. there are 9 columns that I will be collecting from.
Thanks for any help
Tags:
Answers

You would have to use a LEFT function on each individual cell and then add those together.
=LEFT([Column1]@row, 4) + ", " + LEFT([Column2]@row, 4)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!