Delimiters

sccobb

Hello,

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, " ")

Kelly Moore

Hey @sccobb

try this

[Teaching Preference:AFNR]@row +" "+ ["AFNR"]@row

=[AFNR Teaching Preference]@row + " "+ [ASA Teaching Preference]@row

(I am assuming that your column name is "AFNR" and you didn't want quotes around that word).

you might find this information useful

https://help.smartsheet.com/articles/2476826-combine-text-two-or-more-cells-simple-formula

Andrée Starå

Hi @sccobb

Try something like this.

=([Teaching Preference]@row + AFNR@row)

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

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!