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.

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

See Also

ISBLANK()

Did this answer your question?