Returns a Yes/No
expression, as follows:
-
TRUE
if the specified item has no value. (An empty list has no value.) -
FALSE
if the specified item has a value.
Sample usage
ISBLANK("")
returns TRUE
NOT(ISBLANK(""))
returns FALSE
. Equivalent to ISNOTBLANK("")
. See also: ISNOTBLANK()
.
ISBLANK("Hi!")
returns FALSE
ISBLANK(0)
returns FALSE
ISBLANK(LIST())
returns TRUE
. See also: LIST()
ISBLANK(LIST("Red", "Yellow", "Green"))
returns FALSE
ISBLANK([Address])
returns TRUE
if the Address
column has no value, FALSE
otherwise. See also Notes.
ISBLANK(FILTER("Customers", ([City] = "London")))
returns TRUE
if no customers are in London. Equivalent to (COUNT(FILTER("Customers", ([City] = "London"))) = 0)
. See also: COUNT()
, FILTER()
Syntax
ISBLANK(value)
value
- Any singular value of any type, or a list of any type.
Notes
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 (for example, ("" = [Address])
) works around this behavior.