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