If you’re not already sure how to add a drop-down list in Google Sheets, start with this quick guide. Once you have one in your spreadsheet, we can move into App Script to modify the code.

In LibreOffice the drop-down list is called a "combo box." When you a create a form, the combo box draws a drop-down menu on a single line, from which users select from a series of preset values.