Forum Discussion
Solved
Help with Data Validation List
Trying to create a list with two columns and two tables. For table 1....In column 1 you have status and column 2 you have text. In column 1 (status) each row has a dropdown menu (data validat...
- i would create 2 helper columns:
Z1 =FILTER(c2,c1="yes")
AA1 =FILTER(c2,c1="no")
then Data Validation Lists would point to Z1# or AA1# accordingly
i would create 2 helper columns:
Z1 =FILTER(c2,c1="yes")
AA1 =FILTER(c2,c1="no")
then Data Validation Lists would point to Z1# or AA1# accordingly
Z1 =FILTER(c2,c1="yes")
AA1 =FILTER(c2,c1="no")
then Data Validation Lists would point to Z1# or AA1# accordingly