Help

!= Blank() is not working

Topic Labels: Formulas
652 4
cancel
Showing results for 
Search instead for 
Did you mean: 
OctoberFest
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

I am trying to check if the Cell "vB" has a value or not using 

 
IF({vB} != BLANK(),"true","false").
 
But strangely, even blank cells are spitting out the value "true". No clue why. Can anyone help?
4 Replies 4
Sho
11 - Venus
11 - Venus

The BLANK function is only for returning BLANK, so it is not to be used in comparisons.

In Airtable, this works fine.

IF({vB},"true","false/Blank/null")

 

OctoberFest
5 - Automation Enthusiast
5 - Automation Enthusiast

Understood, thanks for clarifying. So what can I use for comparisons? There is a greater if-then-statement around the partial formula I mentioned above and I would like to avoid nesting if-thens.

OctoberFest
5 - Automation Enthusiast
5 - Automation Enthusiast

Nevermind, I think I figured it out. I just have to include the plain {vB} variable as it is in the greater if-then-statement. 

Hi,
JFYI, you can use field name only for 'non-emptiness' check,
use FIND('word', {Text}) to check whether text includes word,
can insert single-word field name without brackets, and omit 'action if false'.  For example:

IF(vB,'yes')