The IN operator (IN in English) is used to check if a given value exists in a list or a set of values.

It’s a very handy tool to simplify multiple comparisons and quickly validate if a value matches a predefined choice.

➡️ Display name :

➡️ Syntax :

➡️ The Example:

In this example, the IN operator checks if the value of the city field matches any of the items in the list. If city is Paris, Lyon, or Marseille, the condition will return true; otherwise, it will return false.

• 1 field 🟡 : city is the value being compared.
• 1 operator 🟣 : IN checks if the value is within a list.
• 1 list 🟡 : ("Paris", "Lyon", "Marseille") represents the set of values to check against.

🟰 The expected result:

• If city is Paris, Lyon, or Marseille, the condition will return true.
• If city is another city, like Toulouse or Bordeaux, the condition will return false.

💡 Practical use:

The IN operator simplifies checks when comparing a value to several others.

It’s ideal for verifying if data belongs to a predefined set of values, whether they are cities, products, statuses, etc.

It helps streamline formulas by avoiding the use of multiple OR conditions and provides a clearer, more concise logic.

• Check if an employee is part of a team
• Verify if a user has access to a specific feature
• Check if a country belongs to a specific region
  
  

📝 Tip: For visibility in the form of a check box ☑️ of the result of your condition, choose the “Boolean” output format in the “option” menu of the column 
1 = will return check ☑️

0 = will return unchecked ☐