Tom Azernour avatar
Written by Tom Azernour
Updated over a week ago

Type: Function

Function: IN

Syntax: IN(value, list)

Description: Returns true if the chosen value is equal to one of the elements in the provided list.

Sample usage:

  • IN(author_username, ["john", "bob"]) returns true if the author_username field value is either “john” or “bob”, and false otherwise.

  • IN(author_username, ["john", "bob"]) ? “Team A” : “Team B” returns “Team A” if the author is either “john” or “bob” and “Team B” otherwise. This value remapping can be used when a grouping per team is required.

Did this answer your question?