ISBLANK()

Is value absent?

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. Equivalent to ("" = [Address]) (but not to ([Address] = ""). as described in Common problems, below).

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()

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 (for example, ("" = [Address])) works around this behavior.

Syntax

ISBLANK(value)

  • value - Any singular value of any type, or a list of any type.

See also

ISNOTBLANK()

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false