All(Text values, Text list)

Returns true if all values specified in the list argument exist in the values argument.

Parameters

values

The comma-separated list of values.

list

The comma-separated list of values to test.

Returns

Boolean

Remarks

You can use this function to work with Multiple Choices (checkboxes) text column values, especially when you need to check whether it contains all of values.

Examples

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

For example, if there is a "Multiple Choices" text column in a table and you want users to find records that include the exact combination of choices they specify, you can use the following custom formula in the view filter: Ask(All([Multiple Choices], [?Multiple Choices])).