Enumlist showing all values - need to be dependent on 1st column choice

[Oscar_Chi]

Hi I have 4 columns, where the 4th column is an enum list.

I want so that if in the first column - A is selected, then my 4th column enum list would only show data in the same row as the first column. If I chose A, then I want to be able to choose 1,2,3 or 2,3, or 1,3 and so on.

example:
1(Enum) 2 (text) 3(text) 4(Enumlist)
A 1
A 2
A 3
B 4
B 5
B 6
C 7
C 8
C 9

[Steve]

help.appsheet.com

Dropdown from Valid_If

How to create a dropdown that depends on a particular list of values.

[Oscar_Chi]

Thank you!

It put me on the right path, so what I wanted was

SELECT(Fruits[Apples], ([Red] = [_THISROW].[Red]))

This returns all the rows/apples that are red (selected from as an option in the form).

source: “SELECT() | AppSheet Help Center”

[Steve]

Well done!