JOIN text function over multiple ranges
I am trying to create a formula that will join a group of element IDs from two entire columns. My latest failed attempt is below:
=JOIN([Element 1 ID]:[Element 1 ID], [Element 2 ID]:[Element 2 ID], ", ")
I'm not sure if I just have the syntax wrong or if the JOIN function is not capable of including multiple ranges. I suppose I could have a formula for each column then join the resulting cells for one group, but I am hoping there is a less convoluted approach.
The goal is to be able to copy all of the Element IDs as a single string of text for pasting into another program.
Thanks in advance.
Comments
-
-
This screenshot might better show what I'm attempting. In this example, I need all 10 element IDs to be joined into a single string in one cell.
-
Try something like this...
=JOIN([Element 1 ID]:[Element 1 ID], ", ") + ", " + JOIN([Element 2 ID]:[Element 2 ID], ", ")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!