List filter constraints with boolean logic

I want to be able to include some not complicated boolean logic when I add a constraint to a list filter.

Specifically filter my list where

field = ("value 1" OR "value 2")

It seems like I only have the ability to combine constraints with AND

The filter you’re looking for is [FieldName] is in Value1:converted to list:plus item Value2

This means, is the field in the list made up of Value 1 and Value 2 (and therefore is logically equivalent to is this field Value 1 or Value 2)

2 Likes

Blimey. That’s a bit convoluted.

Thankyou very much and I will make sure to bookmark this because I know my future self will forget!