paxlegal.blogg.se - How to create a drop down list in google sheets

And.discovered that this task is not too hard! Not finding an add-on for this (why recreate the wheel? :-) I explored creating a script. Today I was asked by a teacher how he could populate a drop-down list on his Google Form from data on a spreadsheet - and have it update as he changed the data. I guess it was only a matter of time before I ended up dabbling with Google Scripts. ( I just created a new related post on how to create a multiple choice question on the form that a bit simplified - takes the "other" answers in a multiple choice question on a form, and updates the multiple choice options with those as options.) You can either click the down arrow to select from the list, or you can begin typing a value in the cell.Ĭlick here to watch this video on YouTube.(Updated on - triggers have been moved!) Click Save and return to the original worksheet.Select Reject Input if you’d like to prevent any value not in your list.

Set Criteria to be “”List from a range”” and select the values you entered on the Values worksheet.

Right click and select Data Validation.

Go back to the original worksheet and highlight the cells where you’d like the drop-downs to appear.

Enter the values you want to have appear in your drop-downs.

Create a new worksheet and name it Values.

You can create an editable copy by clicking ‘File’, then ‘Make a copy’. To see the sample document featured in the video, click here. The video above will guide you through the following steps. This feature is very useful for controlling what collaborators can enter into cells and for allowing you to enter values very quickly, by simply typing the first character or two of a value and then pressing Enter. But, did you know that you can create custom drop-down menus with data validation?

Data validation is one of our favorite tools in Google Sheets, because it gives the Spreadsheet owner even more control over the data that’s entered.