JOIN Command Issue

Bruce Venhuizen
Bruce Venhuizen ✭✭✭
edited 12/09/19 in Formulas and Functions

Getting a #unparseable error with the following Join command below. I want to combine ten different comment cells and join them under another separate Comment cell.

=JOIN([Comments #1]1:[Comments #2]1:[Comments #3]1:[Comments #4]1:[Comments #5]1:[Comments #6]1:[Comments #7]1:[Comments #8]1:[Comments #9]1:[Comments #10]1, "." )

See attached screenshot.

Any assistance would be much appreciated.

2019-08-14_9-23-35.jpg

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!