Drop Down Google Form. Grab the values in the first column of the sheet use 2 to skip header row. From the criteria drop down choose either list from a range or list of items.
The first thing you need to do is open up your google sheets file and select the cell s for which you want to use a drop down list. Therefore google forms allow the copy paste function. Var names ss getsheetbyname name of sheet in spreadsheet.
5 google sheets features you should know.
To do so click on the add section icon and a new one will.