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.
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;