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.