It would be awesome if Airtable’s formula engine could recognize “curly quotes” as the same thing as "straight quotes".
When editing formulas on mobile web browsers, curly quotes are the default. And, when copying and pasting formulas that have curly quotes from other places — such as this forum, which changes quotes to curly quotes outside of a code block, or rich-text editing apps which change quotes — the formulas won’t work upon pasting them into Airtable.
There have been multiple times where I have been scratching my head in confusion over a “seemingly-perfect formula” that doesn’t work properly, but it is actually failing because the quotes are curly.