Apr 25, 2019 09:59 AM
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
Apr 25, 2019 10:10 AM
Apr 25, 2019 10:12 AM
Might have been an issue with formatted quotes? Airtable expects non-formatted quotes.
Apr 25, 2019 11:30 AM
Thanks for the quick response. That worked! I thought I tried it that way but prob didn’t have it formatted correctly.