Skip to main content
Tests if a value matches any candidate value in a subsequent list of candidate values. Returns True if the value matches any of the subsequent candidate values, False if no values are matched. Category: logical Syntax: 
In([value_column], candidate1, [candidates 2+])
Returns: BooleanColumn Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
valuecolumn|any✓ YesThe value to test.
candidate 1any✓ YesThe first candidate to test value against.
additional candidatesvariadic✗ NoAdditional candidates to test value against.

​
Validation

  • Minimum parameters: 2
  • Maximum parameters: Unlimited

​
Examples

In("green", "red", "green", "blue")
Tests if “green” matches any of the candidate values. Result: true 
In([Customer ID], 2000, 3000, 4000)
Returns True for rows where Customer ID is 2000, 3000, or 4000.
Last modified on March 13, 2026