In formulas (expressions), AppSheet doesn’t distinguish between directional quotes (left and right different) and straight quotes. So, until now, I haven’t been able to use directional quotation marks in column names and in concatenate() expressions. Today, however, I hit upon a work around.
First, I noticed that AppSheet had no trouble with the directional quotation marks that I put in cells of my Google spreadsheet:
So, I decided to add a column with the left and right quotations marks
and then invoke them with left() and right() expressions:
I’m quite happy with the result:
It’s a fair amount of work, though. So, if anyone knows of a better, less complicated way of doing it, I’d be happy to learn about it.