Skip to main content

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?

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")

 

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.

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. 

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')

Reply


Terms & Conditions