Filtering a table based on a column value for a Related Row:
- There needs to be an “equal to” option instead of just “contains”
- You need to be able to select or search for the value (values) you want to filter on rather than typing it it manually.
- For even better functionality, allow a cell reference to be included as the filter value via =C9 so whatever value is in cell C9 is used as the filter value. The “=” character would be how you know that what follows is a cell reference.