These docs are for v1.0. Click to read the latest docs for v1.2.

Returns true if the expression is empty.

  • Strings passed into the function are checked if they are an empty string.
  • If an array is passed into the function, the function will return true only if every item in the flattened array is equal to the empty string.
  • If a value that is not a string or array is passed into the function, the value will be converted to a string before checking if the value is an empty string.
  • If an object is passed into the function, the function will return true only if the object has no keys.

Syntax

=ISEMPTY(expr)

Arguments

ArgumentTypeDescription
exprString, Array or ObjectThe value to check for emptiness

Examples

=ISEMPTY("")true
Checks if the string "" is empty.

=ISEMPTY(123)false
Checks if the number 123 is empty. 123 is converted to the string "123", which is not empty and the function returns false.

=ISEMPTY(@"Property 1")false
Checks if the shape data property "Property 1" is empty. Because "Property 1" is not empty (it has the value 1), the function returns false.

=ISEMPTY(@"Property 4")true
Checks if the shape data property "Property 4" is empty. Because "Property 4" is empty, the function returns false.

=ISEMPTY(OBJECT("A", 2))false
Checks if the object is empty, and because the object has a key-value pair the function returns false.