Formula to join text strings from 10 columns

I tried Join Function to add text strings from 10 different column using following but no success:

=JOIN([Region 1]:[Region 1], [Region 2]:[Region 2],[Region 3]:[Region 3],””)

Can anyone help please?

Thanks

Prajna

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!