Help

Conditional Formula not working?

Topic Labels: Formulas
1776 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Sharee_Jefferso
4 - Data Explorer
4 - Data Explorer

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

3 Replies 3

Hi @Sharee_Jefferson - this worked for me:

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

Screenshot 2019-04-25 at 18.10.27.png

JB

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.