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.
Single Quote Possible Bug
+35Unfortunately, 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.
@Jason
+20Unfortunately, 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.
@Jason
To turn on Smart Quotes on an iPad:
For the MacBook Air, try this:
Hope this helps.
Mary Kay
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.