Any(Text values, Text list)

Returns true if at least one value from the list argument exists in the values argument.

Parameters

values

A comma-separated list of values.

list

A comma-separated list of values to test.

Returns

Boolean

Remarks

You can use this function with a Multiple Choices (checkboxes) text column, especially when you need to check whether it contains at least one of the specified values.

Examples

• Any("A,B,C,D", "D,A") returns true.
• Any("A,B,C,D", "D,E") returns true.

For example, if there is a "Multiple Choices" text column in a table and you want users to filter records that include any value from the combination they select, you can use the following formula in the view filter: Ask(Any([Multiple Choices], [?Multiple Choices])).