how to make a drop down list in google sheets

However, if you try and add a new department onto the end of the list, it won’t automatically be included (you’ll have to update the Data Validation to include it).I'm not sure why but this google script won't run.am I missing something? Should just be a straight forward drop-down list in google form that pulls from a list in a google sheet. The drop-down will automatically update and include your new department.

You can also insert a new row into your table of departments (by going to the Insert tab, and choosing Cells and Shift Down) and add another department. In the example below, I changed Marketing to Advertising & Marketing. Note – if you update any of your departments, the drop-down list will update automatically. You should now see a drop-down for department. Note – Sheets will make this range absolute for you. So select G2 to G6 (the list of departments) and click OK. But this time, we don’t have to type in the departments – they are listed in column G.Ĭlick on the drop-down next to Criteria and choose List from a Range. We are now going to add a dropdown to the Department Column. If you try and enter incorrect data, as soon as you press enter you’ll see the help text appear: You should now see your list when you click on the drop-down in cell B2. (For example “Choose day from list please” or “Click and enter a value from the list of items”) This means that the user will be warned that they are entering data that isn’t expected.įinally, you can add some validation help text. If you think there might be a time when someone needs to input an option that isn’t part of the drop-down list, then choose Show Warning. First, Go to the cell where you want the list to appear and select Data > Data Validation from the menu, just as you did for the first list. If you don’t want any invalid data entered (and I don’t!) choose the Reject Input option. How Do I Create a Dependent Drop-Down List in Google Sheets for Multiple Rows In order to create the dependent drop-down list. Make sure there is a tick in the Show drop-down list in cell boxĭecide how you want to handle invalid data. (For example, Monday,Tuesday,Wednesday,Thursday,Friday) Type in the options you want to display in your drop-down, separated by commas. (If it’s not, click on the select data range icon, highlight the cells you want to add a drop-down to, then click OK)Ĭlick on the drop-down next to Criteria and choose List of Items. Make sure the cell range here is correct. Click on the Data Tab, and choose Data Validation.

How to make a drop down list in google sheets