Ok going to need some help here. Have searched the community for an answer with no joy!
I have section which features a single select control, the contents of which are column 1 of table 1.
Table 2 uses a table lookup for column 1 table 1.
I want filter a view of table 2 based on single select of table 1 column 1 value. This doesn’t seem to work!
Second table with lookup from first table
Single select control
Filter on view of second table using select control
This shows no results. I have tried using = or contains with no joy.
I presume it’s because it’s trying to match a select control with lookup results?
Any suggestions? Many thanks
Here is the sheet for reference -> https://coda.io/d/_d7XqHIIq98e