Please help correct my formula - copy/paste results in carriage return and quotes around text

Options
Ami Veltrie
Ami Veltrie ✭✭✭✭✭✭
edited 09/14/22 in Formulas and Functions

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

-P"

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!