Conditional Formula not working?

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

Hi @Sharee_Jefferson - this worked for me:

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

JB

1 Like

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

1 Like

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

1 Like