Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

!= Blank() or NOT(Blank()) - Which one is correct?

103 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,

I tried using != Blank() and NOT(Blank()) on several occasions for my formulars and have been getting different results. I'm not sure why.

Is it because only one of the two works and the other is ignored by my formular? Or does it depend on the format that I am trying to evaluate (dates, integers, strings)? 

Any help on clarifying this would be greatly appreciated and prevent mistakes in the future.

3 Replies 3

You've mentioned "NOT(Blank())" - but I'm not sure this makes sense?

For example, if I have a Currency Field called "Price" that contains a numeracy value, in another Formula Field, to check if "Price" contains a value or is blank, I would write the formula;

NOT(Price)
 

Well, if I look at the documentation (https://support.airtable.com/docs/identifying-blank-values) I would have to write Price = Blank(), to check if it is blank. And I am interpreting, that != Blank() would be the way to check if it is NOT blank. But like I said: I've been using != Blank() and NOT(Blank()) with different results. Confusing.

Well, to clarify what you're doing, what result are you trying to achieve? What field types are you checking for blank values (Link Fields, Numeric Fields, Email fields etc), and what is the output you're needing in the formula field that's checking if the target fields are blank? In my Not(Price) example, whenever there's a value a 0 will return, if price is blank then a 1 will appear.


Alternatively, in my formula field if I write;

If(Price, true(), false())
 
Then this will return a 1 when my price field has a value, and a zero if price is blank.