Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Creating two separate data validation dropdown menus in same Sheet

Is it possible to create multiple and separate data validation dropdown menus in a Sheet? ie. I want yes/no in column G, and I want department names dropdown in column H.

Ty!

Solved Solved
0 2 230
1 ACCEPTED SOLUTION

Hi,

It should be possible. Please refer the attached screenshot. I hope you are refering to the same.workspace.JPG

View solution in original post

2 REPLIES 2

Hi,

It should be possible. Please refer the attached screenshot. I hope you are refering to the same.workspace.JPG

Correct. 

And here is a screenshot of what my two columns look like.  One with data validation set up, and the Column M I want to set up with separate data, keeps picking up the data validation from Column N.  I want the data validation for Column M to be a totally separate dropdown.  Ty!

Screenshot data validation.jpg

Top Labels in this Space
Top Solution Authors