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.