クラシックファイルタイプは2021年1月をもって使用できなくなりました。クラシックファイルを移行することも、PDFをダウンロードすることもできます。詳細はこちら

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. 

0

コメント

6件のコメント

日付 投票
  • 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

サインインしてコメントを残してください。