Take a look at this screenshot:
The lookup is pointing to a relation that is pointing to a rollup,
And the only options I get are ‘Is not empty’ and ‘is empty’ when I want ‘is equal to 1’ or something like that
Is this a bug, forgotten feature, or weird intended behavior?
Most likely because it’s a multiple relation. You can’t compare a single value to a lookup array that can potentially hold thousands of values. Needs to be a single relation with a lookup to a single value.
Thanks! It seems like I mindlessly checked ‘Match Multiple’