I have two formulas I am trying to add delimiters to but I keep getting an unparsable error. I am trying to join text in a few cells and have a space added between the text. Any help would be appreciated. Thank you.

=([Teaching Preference:AFNR]@row + ["AFNR"]@row, " ")

=JOIN([AFNR Teaching Preference]@row + [ASA Teaching Preference]@row, " ")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!