How do I filter by a list of terms?

Filter a column by a list of terms using the in function. For example, to include rows where column is “apple”, “orange”, or “pear”:

filter in(column, "apple", "orange", "pear")

To exclude rows where column is “water”, “earth”, or “fire”:

filter in(column, "water", "earth", "fire")