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.