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

IN

Returns a boolean indicating if a specified item (needle) is inside of a given set (haystack). Note that the haystack must be an array.

Syntax

=IN(haystack, needle)

Examples

=IN([1,2,3], 1)true
=IN([1,2,3], 0)false
=IN([OBJECT("A", 1), OBJECT("B", 1)], OBJECT("A", 1))true
=IN([OBJECT("A", 1), OBJECT("B", 1)], OBJECT("A", "B"))false