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