Posts Tagged ‘Google Sheets’

Create drop down menu options in Google Sheets


You can easily create a drop-down menu of options in cells in Google Sheets by using the Data Validation tool. See the instructions link to youtube video below.


I use this for tracking data on my own, or for students doing a running record of self-assessment.

Drop down menus
Use the Data Validation tool to create drop-down menus

https://www.youtube.com/watch?v=v3uvwbpQcW4

Advertisements

Auto sort results of a Google Form so newest responses are on top!


If you use Google forms to collect data of a long period of time you may want the newest results to post to the top of the spreadsheet. For example, I use a form as a way to track books that kids borrow, I’d rather have the newest book to be borrowed appear at the top of the list.


Here is one way you can do this.

  1. On the bottom left of the sheet click the + to create another sheet
  2. In cell A1 paste the following formula:
    1. =sort('Form Responses 1'!A:H, 1, False)
  3. You may want to double click the title of the new sheet (Which will be “Copy of Form Responses 1” and change it to something more descriptive “Sorted” is what I chose.

 

Remember, this new sheet, “Sorted,” is mirroring the “Form Responses” sheet, so any changes you make to the content will show up on the “Sorted” sheet.

%d bloggers like this: