Formula is resulting in carriage return and quotes around text

Here is my formula:

=[Client Name (Avi)]@row + "-" + LEFT([Request Category]@row, 1) + "-" + MID(Created@row, 7, 2) + "-" + [Request ID]@row + "- " + JOIN([Services Requested - Utility]@row + [Services Requested - Waste]@row + JOIN(" -P"))

When I copy/paste the cell (or export to Excel), the text looks like this (two rows, with quotes):

"Client Name-O-22-01986- Electric


I also tried copy/paste into a different sheet, here's the result:

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!