Multiple drop down options in single cell.
Hello, is there a way to create multiple drown down options in a single cell? When creating my sheet, I can only create one option for each cell which is extending my spreadsheet. I am looking to have one cell that contains all options, that would be helpful for the viewers of this document.
-
Hi Tracy Kyle! Do you mean you'd like to have a drop down that has a list of options to choose from? That can be done using Data Validation from the right hand panel and then you can additionally put conditional formatting onto each option in the drop down list. Or you'd like multiple drop downs on one cell? That wouldn't be possible.
0
Thanks Lars Skaar. Yes, the latter. I was referring to having the ability to select multiple options in a single cell drop down as if two or more values are true.
Example: Dropdown menu: Tracy, Lars, Tina, and Sue. As a response, I would like to check Tracy & Lars. Right now, I have to create a column for each person, with the same names in each column. If I'm understanding correctly, this is not possible. Truly appreciate the quick response.
0
Tracy Kyle Thanks for waiting! Multiple selections off one drop down is not possible at this time. I will definitely spin up an idea ticket for you and then when there are any updates you will be notified! Thanks so much!
0
Thanks so much.
0
Please add me to that ticket so I can follow. We'd like that ability as well.
0
Commenti
6 commenti