Hello, I’m trying to filter a table view based on a value that is assigned to a user in another table.
The problem I seem to be encountering is that lookup objects in a table where multiple objects can be selected cannot be directly compared to other lookup objects. I have tried using the “in” and “contain” formulas with no luck.
I have created a very basic example below
In the Troubleshooting table I created at the bottom, you can see that if I have only one field value (eg Chemistry) selected for user1, the values are not equal, but at least the contains formula seems to work. However, if you add another field to user 1 (eg Chemistry, Biology), both contains formulas will report false.
There must be something about these data types that I’m missing.