|
Klassiske filtyper er ikke lenger tilgjengelige for bruk fra og med januar 2021. Du kan overføre klassiske filer eller laste ned en PDF-fil. Finn ut mer

Multiple drop down options in single cell.

Be om demo

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. 

0

Kommentarer

11 kommentarer

Dato Stemmer
  • Lars Skaar

    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
  • Tracy Kyle

    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
  • Lars Skaar

    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
  • Tracy Kyle

    Thanks so much. 

    0
  • Linda Walter

    Please add me to that ticket so I can follow. We'd like that ability as well.

     

    0
  • Lars Skaar

    Got that for ya Linda Walter!

    0
  • Leslie Norris

    Is / was this feature ever implemented? (multi-select options in a drop-down list)

    0
  • Isabel Messore

    Hi Leslie Norris, 

    This has been added to our roadmap but is yet to be released. I can add you to the request and we'll automatically notify you of any updates on progress!

    0
  • Shelby Unruh

    Looking forward to when this feature becomes available! Can I please be added to the request to receive notifications? 

    0
  • Brooke Mortvedt

    Hi Shelby Unruh - Thanks for commenting, I have you added to this request! I hope you have a great day! 😊

    0
  • Alexis Edge

    Great to hear this is in progress. I could also benefit from this!

    0

Logg på for å legge inn en kommentar.