Examples

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

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

ISNOTBLANK("Hi!") : TRUE

ISNOTBLANK(0) : TRUE

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

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

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

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

Syntax

ISNOTBLANK( this )

Arguments

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

Return Value

Yes/No: TRUE if this has a value, FALSE otherwise. An empty list has no value.

See Also

ISBLANK()

Did this answer your question?