how to insert a drop down list in google sheets

Var primaryDropRange = 'A2:A100' //Range which primary dropdown set

Var primaryDataRange = 'A2:A213' //Data range for primary dropdown Var dropSS = 'DropDown' //Name of the sheet which dropdown list to be created Var dataSS = 'Lists' //Name of the sheet that contain data for dropdown lists Then copy and replace the default script with the following script. If you are new to Google Apps Script you can open the Apps Script editor by going to Tools → Script Editor in the Google Sheet. The list is populated from the data in the “ Lists” sheet as mentioned before. The following script (function: createPrimaryDrpdwon) applies data validation to the range A2:A100 and creates a “region” dropdown list in each cell. Creating primary dropdown list in Google Sheets with Apps Script You can learn more about Class DataValidationBuilder from this Google Apps Script tutorial. However, unlike in the previous post, here I apply the data validation to relevant cells using Google Apps Script. In this method also, I am using data validation to create a dropdown list. You are also advised to do the same since I am going to use these names in the code. I have named the Sheet with the list of data for populating the dropdown as “ Lists” and the Sheet in which the dropdown menu created as “ Dropdown“. The primary dropdown is populated by “Region” and the Dependent dropdown list is populated by “Countries” where a Region has multiple countries. Wrapping Up Preparing the Google Sheets and sample dataįor this example, I am going to use the following data stored in another sheet of the same spreadsheet to populate primary and dependent dropdowns.Creating the dependent dropdown list in Google Sheets with Apps Script.Creating primary dropdown list in Google Sheets with Apps Script.Preparing the Google Sheets and sample data.

How to insert a drop down list in google sheets