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.