Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Conditional Formula not working?

Topic Labels: Formulas
1195 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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.