JOIN text function over multiple ranges

Cory Griffis
Cory Griffis ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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. 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!