Can I make the all drop down options appear in Google Spreadsheet

  • Profile Image
    eltopochofeliz
    Asked on April 02, 2016 at 03:19 AM

    I wana make a drop down, and the option of drop down must be import from a spread sheeat in google drive, how i can do it?

  • Profile Image
    Jan
    Answered on April 02, 2016 at 07:44 AM

    Unfortunately, only the chosen answer will appear on the spreadsheet. If you allow multiple options to be selected then all the selected answers will appear.

    Select the drop down field and then turn on the "Allow Multiple" option in the top toolbar.

    Here's how it'll look like in the spreadsheet:

    You might want to check if the Dynamic Drop down widget will work for you.

    Here's what you'll get in the spreadsheet:

    Hope this helps. Thank you.