Examples

IN("a", {"a", "b", "c"}) : TRUE

IN("bc", {"a", "b", "c"}) : FALSE

IN("d", {"a", "b", "c"}) : FALSE

IN("Red", {"I'm bored!"}) : FALSE

IN("@", LIST([Email])) answers the question: is the value of the Email column exactly @ and nothing else? Equivalent to ([Email] = "@"). See also: LIST().

IN(LEFT([Sentence], 1), {".", "?", "!"}) answers the question: is the left-most character of the value of the Sentence (LEFT([Sentence], 1)) a period (.), question mark (?), or exclamation mark (!)? Equivalent to CONTAINS(".?!", LEFT([Sentence], 1)). See also: CONTAINS(), LEFT().

IN(USEREMAIL(), AppUsers[Email]) answers the question: is the current app user's email address (USEREMAIl()) found in the list of Email addresses in the AppUsers table (AppUsers[Email])? See also: USEREMAIL().

IN(CONTEXT("ViewType"), {"Deck", "Gallery", "Table"}) answers the question: is the currently-displayed view's type Deck, Gallery, or Table? Equivalent to OR((CONTEXT("ViewType") = "Deck"), (CONTEXT("ViewType") = "Gallery"), (CONTEXT("ViewType") = "Table")). See also: CONTEXT(), OR().

Syntax

IN( needle , haystack )

Arguments

needle (any): The value to be found. This value's type must be compatible with that of the items of the search list (haystack).

haystack (EnumList or List of any): A list of items to be searched. The type of items must be compatible with that of the search target (needle).

Return Value

Yes/No : TRUE if the search target (needle) matches at least one item in the search list (haystack); otherwise FALSE. Note that the match is case-insensitive: upper- and lower-case letters are equivalent.

See Also

CONTAINS(), FIND(), INTERSECT(), LIST(), SPLIT()

Did this answer your question?