I have an ENUMLIST storing data as expected. I use SUBSTITUTE to put it into the clients format but when the data is exporting to csv it distributes across columns (due to the comma) when it should stay in one single field.
I tried wrapping it in another set of commas but appsheet doesn’t like the expression.
“^”&SUBSTITUTE([BIN Refurb Type],",","^,^")&"^"
How can I get the data to appear only in the single field vs. parsed out? A million thanks