In Google Sheets, I want to set up a filtered view like this.
Row 1 = column headings
Row 2 = filter criteria
Rows 3... = data
I want the user to type a value into any column of row 2, and this will dynamically update which rows are displayed in the filter view. Is this possible? For example, starting with column C, I enter "Disney" into C2, then I enter this formula as a filter, but it returns only row 2.
=REGEXMATCH(C2, $C$2)
But if I enter it as =REGEXMATCH(C2, "Disney")
then it correctly returns all rows with Disney in column C.
Here is an example spreadsheet: https://docs.google.com/spreadsheets/d/1o3cvenwSuimKo9gZuehqo8Y-LEZ_c397JJk7LNmfwQM/edit?usp=sharing