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
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โ
Well done!
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |