VALUES
Returns the dereferenced values of all keys available on the specified parameter. Defaults to THIS if no argument provided. (When on a shape data property, VALUES(THIS) always returns at least one error value due to a circular reference.)",
Syntax
=VALUES(obj)
Arguments
| Argument | Type | Description |
|---|---|---|
| obj | Any | The object or reference to test |
Examples
=VALUES(OBJECT("A", 1, "B", 2))→[1, 2]
Returns the values of the given object
=VALUES()→[123, "Hello World", true, #ERROR!]
Returns the values of the current object including at least one error value
Updated 9 months ago