ISNOTBLANK()

Returns a Yes/No expression, as follows:

• TRUE if the specified item has a value.

• FALSE if the specified item has no value. (An empty list has no value.)

Sample usage

ISNOTBLANK("") returns FALSE. Equivalent to NOT(ISBLANK("")). See also: ISBLANK(), NOT()

NOT(ISNOTBLANK("")) returns TRUE. Equivalent to ISBLANK("").

ISNOTBLANK("Hi!") returns TRUE

ISNOTBLANK(0) returns TRUE

ISNOTBLANK(LIST()) returns FALSE. See also: LIST()

ISNOTBLANK(LIST("Red", "Yellow", "Green")) returns TRUE

ISNOTBLANK([Address]) returns TRUE if the Address column has a value, FALSE otherwise.

ISNOTBLANK(FILTER("Customers", ([City] = "London"))) returns TRUE if any customers are in London. Equivalent to (COUNT(FILTER("Customers", ([City] = "London"))) <> 0). See also: COUNT(), FILTER()

Syntax

ISNOTBLANK(value)

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

See also

ISBLANK()