ISBLANK()

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.

See also

ISNOTBLANK()