Forum Discussion

J-Des000's avatar
J-Des000
Brass Contributor
Mar 29, 2023
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...
  • mtarler's avatar
    Mar 29, 2023
    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

Resources