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.