Filter spreadsheet by user-entered value in first row

Question

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

Answer 1

This won't be possible because you unintentionally create a circular reference by referring $C$2 from inside of the range C1:C. Therefore you will need to put it outside of the box like for example by swapping 1st & 2nd row and creating green filtered view from 2nd row onwards:

=REGEXMATCH(C3, $C$1)