Function to determine if a list item belongs to a subset of the list
I'm trying to build an exception module to check that all items in a particular list with a particular property residing in another module belongs to a subset in the list. Is there any function like ISSUBSETOF(x) to determine if a particular item in a list belongs to a subset of the list? To illustrate, in a List called Products, there are many properties and among which, there are two Boolean properties: Managed Product and Sector Specific Product. The Product List also contains a subset called Strategic Sales Products that groups all the products with both properties being TRUE. The property is being updated once 6 months and I want to build a module to identify if there are items within the list with both property being true and is not defined in the subset.