In my application I have two fields of type EnumList called List 1 and List 2.
I want an error to show up if the data in list 1 contains the same data in list 2 and vice versa.
I am using the following formula in list 1:
NOT(IN([_THIS], [List 2]))
The expression result reads as follows:
This statement is false: …(The value of column ‘List 1:’) is one of the values in the list (The value of column ‘List 2:’)
This is exactly what I want and it does work, however it only works when I have one entry in list 1.
The validity error message will for example show up if I have the entry apples in both list 1 and list 2, but not if I have apples, oranges in list 1 and just apples in list 2.
What formula should I use to restrict entries that contain a specific word from list 2?
Thanks in advance for any help given.