Choosing Buttons or Dropdown for Columns using data validation with lists

Iโ€™m using Ticket List[Equipment Type] as my โ€œValid Ifโ€ constraint for this column but I think by default there are not may values so it shows up as buttons instead of a list.

3X_c_8_c889d0b66ad1cbe060d43914f620c66ddc4d713a.png

Any trick to using dropdown lists for all columns that use data validation?

0 3 407
3 REPLIES 3

3X_2_5_25e3ef68fae58be0c85b096f8673ed852901422c.png

It works but I get these errors and my conditional constraints donโ€™t work.

Those arenโ€™t errors. They are warnings, and you can safely ignore them since you populate the dropdown with your valid_if.

What?

Top Labels in this Space