Single Quote Possible Bug

Topic Labels: Automations
718 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I ran into a problem using functions like DATEADD({Date 1}, 10, ‘days’). It took forever to find the syntax error AirTable was reporting. It turned out that the ’ coming from some keyboards (mac, ios) was not recognized as the right character. I could fix the formula by copying and pasting the single quote but I could not type it. I was wondering if I was using the wrong key but I could not find another single quote.

2 Replies 2

Unfortunately, Airtable’s formula fields only recognize straight quotation marks instead of curly/stylized quotation marks. On iOS, you can get a straight quotation mark by holding down the quotation mark key (either single or double quote key) and you will see a straight quotation mark option.


Hi @Jean_Peccoud

To turn on Smart Quotes on an iPad:


For the MacBook Air, try this:


Hope this helps.

Mary Kay