Open an existing spreadsheet in Google Sheets and head to the Apps Script menu (refer to the steps above). We deleted the existing code and entered a code below to convert the sheet into a table.

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.