Comparing Lists and Removing Values

How would I create a valid_if formula to compare 2 lists and then remove values that exist or do not exist in another list?

For example, I have List A and List B. I want to use a valid_if to only allow entries that “do not” exist in List B but exist in List A.

Solved Solved
0 1 1,300
1 ACCEPTED SOLUTION

tony1
Participant V
1 REPLY 1

tony1
Participant V

You could try this: [List A] - [List B]

See “List Subtraction” here: https://help.appsheet.com/expressions/expression-types/list-expressions-and-aggregates

Top Labels in this Space