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.