ISNOTBLANK()

Is value present?

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.

See also

ISBLANK()

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu