I’m trying to figure out how to filter a list by two different columns. I’m working with a project list. Each projects has one “lead department” and one or more “resource departments”. These columns both lookup from a “Departments” table. I want to provide an interactive filter to show any project wherein the selected department is contained in the “lead” or “resource” column.
Thanks so much