All(Text values, Text list)
Returns true if all the values specified in its list argument exist in the values argument.
- The comma-separated list of values.
- The comma-separated list of values to test.
All("A,B,C,D", "D,A")returns true.
All("A,B,C,D", "D,E")returns false.
You can use this function in the filter of a view that asks the user for a checkbox column. For example, if there is a "Multiple Choices" text column in a table and you want the user to find records including an exact combination of choices asked by them, you can use the following formula in the filter of the view:
Ask(All([Multiple Choices], [?Multiple Choices])).