I’m trying to use this formula: IF({Release Date}=BLANK(),“ :white_check_mark: ”,“ :no_entry: ”) but I’m getting the error message: Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.
I just want it to show the :no_entry: emoji if the the Release Date field is blank and the :white_check_mark: if not. I have tried IF({Release Date}=BLANK(),“ :no_entry: ”) as well as IF({Release Date}=BLANK(),“yes”,“no”) Sorry if this is a dumb question, I tried looking online and the solutions I found gave me the same error message
Conditional Formula not working?
+18Hi @Sharee_Jefferson - this worked for me:
IF({Release Date}=BLANK(),'✅','⛔️')
JB
+18Hi @Sharee_Jefferson - this worked for me:
IF({Release Date}=BLANK(),'✅','⛔️')
JB
Might have been an issue with formatted quotes? Airtable expects non-formatted quotes.
Might have been an issue with formatted quotes? Airtable expects non-formatted quotes.
Thanks for the quick response. That worked! I thought I tried it that way but prob didn’t have it formatted correctly.
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.