How to create a double filter for a referenced value?

[Lance]

One of my columns references a table that has rows which can be related to one another.
Similar to how sub folders work on explorer. There are many folders which contains sub-folders that have files in them.

Except in the table, the directory structure is broken down so that there are three columns. The first column is the name of the highest parent folder, the second column is the name of the sub-folder, and the third is the file.

Column A | Column B    | Column C
example1 | subfolderA  | file1
example1 | subfolderA  | file2
example1 | subfolderB  | file1
example2 | subfolderA  | file1

Is it possible to create drop downs to filter the data when it is just a referenced column?

So that if I select example1 in the first dropdown, it will only show the column B’s that have a column A of the value example1

[Jin_Tan]

I do not really understand your question, but you may try SELECT() function as it usually do the filter work.

[Steve]

help.appsheet.com

Dependent Dropdown

How to make a dropdown with choices that depend on the value selected in another dropdown.