Examples
ISBLANK("") : TRUE
NOT(ISBLANK("")) : FALSE. Equivalent to ISNOTBLANK(""). See also: ISNOTBLANK().
ISBLANK("Hi!") : FALSE
ISBLANK(0) : FALSE
ISBLANK(LIST()) : TRUE. See also: LIST().
ISBLANK(LIST("Red", "Yellow", "Green")) : FALSE
ISBLANK([Address]) : TRUE if the Address column has no value, FALSE otherwise. Equivalent to ("" = [Address]) (but not to ([Address] = ""); see Common Problems, below).
ISBLANK(FILTER("Customers", ([City] = "London"))) : TRUE if no customers are in London. Equivalent to (COUNT(FILTER("Customers", ([City] = "London"))) = 0). See also: COUNT(), FILTER()
Common Problems
ISBLANK([Address]) is not equivalent to ([Address] = "') because the is-equal-to operator (=) will always return TRUE if the second operand is a blank value, regardless of the first operator. Swapping the operands (e.g., ("" = [Address])) works around this behavior.
Syntax
ISBLANK( this )
Arguments
- this : Any singular value of any type, or a list of any type.
Return Value
Yes/No: TRUE if this has no value, FALSE otherwise. An empty list has no value.