This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
This formula is being accepted in a field, and is working:
IF({NOTES}=“to June 2022”,“Yes”,“No”)
but both of these more elaborate versions are being rejected:
IF(OR({NOTES} = “to Dec 2021”, {NOTES} = “Life”, {NOTES} = “Prepaid 2022-2023”), ”Yes", “No...
I experienced the above flickering problem today, for the first time in more than three years considerable use of Airtable. I'm using Safari on a Mac. Interestingly, the flickering occurred only on some tables in some bases - not everywhere. I decide...
Ah-ha! Now I understand. For convenience, I had been using an app called Drafts on my Mac to create the code and hadn’t noticed the formatted quotes. That all makes sense and I will be careful in future.
Thank you. It worked for me too, as did this expanded version. It seems that both single quotes and spaces after commas separating arguments in the OR() are critical:
IF(
OR({NOTES} = ‘to Dec 2021’, {NOTES} = ‘Life’, {NOTES} = ‘Prepaid 2022-2023’, {N...
I don’t think Matthew’s suggestions provide a solution. I would like to make certain columns of a large membership table accessible at a help desk, including mobile phone and email details. The ability to print the entire list to a PDF or printer is ...
