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?
!= Blank() is not working
+3The 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")
+3Understood, 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.
+3Nevermind, I think I figured it out. I just have to include the plain {vB} variable as it is in the greater if-then-statement.
+25Nevermind, 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')
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.