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.

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.

See Also

ISNOTBLANK()

Did this answer your question?