Use multiEnum:EnumID (not enum:EnumID) for multi-select columns. The prefix multiEnum enables the multi-select picker. Using enum creates a single-selection dropdown instead.
Shows rows where the multi-enum field contains any of the specified values:
Click the column filter icon
Switch to Filter by Condition mode
Use the Contains function
Select enum values to match
This returns rows that have at least one of the selected values.
Use Filter by Condition with Contains when you want to find all rows that include specific enum values, even if other values are also selected. This is especially useful for impact tracking where you want to find all risks affecting “Patient Safety” regardless of other selected impacts.
Invalid child selections are automatically removed
Users can still select multiple values from the filtered list
If no valid options remain, the field is cleared
Changing the parent enum value removes any multi-select child values that are no longer valid according to the mapping. For example, switching from “electrical” to “mechanical” would remove “power”, “control”, and “sensors” selections and allow only “actuators”, “structure”, and “fasteners”.
You should now see a multi-select dropdown when clicking the column. Select multiple values and verify they appear as a formatted chip list in the cell. Test filtering using both “Filter by Value” (exact match) and “Filter by Condition” with Contains (partial match) to confirm both modes work correctly.