Simple conditional work does not work, does anyone...

[Sharee_Jefferso]

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

[JonathanBowen]

Hi @Sharee_Jefferson - this worked for me:

IF({Release Date}=BLANK(),'✅','⛔️')

JB

[JonathanBowen]

Might have been an issue with formatted quotes? Airtable expects non-formatted quotes.

[Sharee_Jefferso]

Thanks for the quick response. That worked! I thought I tried it that way but prob didn’t have it formatted correctly.