Issue combining multiple cells in one sheet
I am trying to combine 4 numerical cells in a single sheet into another cell/different column in the same sheet. When i do this it is creating a sum of the first two cells and combining the rest.
1 1 00614 100
Outcome is 200614100
Formula =JOIN([Grouper 1 (Entity)]@row + [Grouper 2 (Type)]@row + [Grouper 3 (Numerical Workday Center #  5 Digits)]@row + [Start Ticker # (Always Starts With 100)]@row)
I do not understand why it would add the first two and then combine the others. Each column is set to text/number
Best Answer

Hi @mcaulism
The JOIN syntax is JOIN(range, delineator) .
In your formula, the range is something like 123+455+ABC, so the formula first gets the 123+456= 569 and then combines it with ABC. 😀
To treat Number+Number to act like NumberNumber or 123+456=123456, you can add "" as =123+""+456.
Or, if you change the formula to JOIN([Grouper 1 (Entity)]@row:[Start Ticker # (Always Starts With 100)]@row), the JOIN function will treat all the values in the [Grouper 1 (Entity)]@row:[Start Ticker # (Always Starts With 100)]@row range as text, and you will get the desired result like 12345ABC.
Answers

Hi @mcaulism
The JOIN syntax is JOIN(range, delineator) .
In your formula, the range is something like 123+455+ABC, so the formula first gets the 123+456= 569 and then combines it with ABC. 😀
To treat Number+Number to act like NumberNumber or 123+456=123456, you can add "" as =123+""+456.
Or, if you change the formula to JOIN([Grouper 1 (Entity)]@row:[Start Ticker # (Always Starts With 100)]@row), the JOIN function will treat all the values in the [Grouper 1 (Entity)]@row:[Start Ticker # (Always Starts With 100)]@row range as text, and you will get the desired result like 12345ABC.

@jmyzk_cloudsmart_jp That worked perfectly. Thank You!!!

Happy😁 to help.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!