How to Sort Google Sheets and Forms Entries in Reverse Chronological Order
13811
post-template-default,single,single-post,postid-13811,single-format-standard,bridge-core-1.0.7,ajax_fade,page_not_loaded,,qode-title-hidden,qode_grid_1300,hide_top_bar_on_mobile_header,qode-content-sidebar-responsive,qode-child-theme-ver-1.0.0,qode-theme-ver-18.2.1,qode-theme-bridge,disabled_footer_bottom,qode_header_in_grid,wpb-js-composer js-comp-ver-7.9,vc_responsive

04 Jan How to Sort Google Sheets and Forms Entries in Reverse Chronological Order

Posted at 10:09h in education by

Last week a reader reached out to me for some guidance on how to handle a Google Form that had more than one hundred submissions. He was looking for a way to quickly find the most information submitted in the most recent entries. My solution to that problem was to use Z-A sort in the Google Sheet associated with the Form. By doing that you will see the most recent entry at the top of the sheet. 

In the video that is embedded below I demonstrate how to sort Google Sheets and Forms entries in reverse chronological order. 

Video – How to Quickly Sort Google Sheets in Reverse Chronological Order

Applications for Education
Sorting the Google Sheet attached to a Google Form is something that I’ve done for years. I do that so when I have students completing something like a practice quiz over the course of a week I can quickly find the latest submission and review it with a student without having to constantly scroll to the bottom of the sheet.

Learn much more about Google Forms in this playlist of 40 Google Forms tutorials videos.

Are you a tech coach or media specialist looking for some new ideas to share with your colleagues? If so, 50 Tech Tuesday Tips is an eBook you need. You can get it right here.

Last week a reader reached out to me for some guidance on how to handle a Google Form that had more than one hundred submissions. He was looking for a way to quickly find the most information submitted in the most recent entries. My solution to that problem was to use Z-A sort in the Google Sheet associated with the Form. By doing that you will see the most recent entry at the top of the sheet. In the video that is embedded below I demonstrate how to sort Google Sheets and Forms entries in reverse chronological order. Video – How to Quickly Sort Google Sheets in Reverse Chronological OrderApplications for EducationSorting the Google Sheet attached to a Google Form is something that I’ve done for years. I do that so when I have students completing something like a practice quiz over the course of a week I can quickly find the latest submission and review it with a student without having to constantly scroll to the bottom of the sheet. Learn much more about Google Forms in this playlist of 40 Google Forms tutorials videos.

Are you a tech coach or media specialist looking for some new ideas to share with your colleagues? If so, 50 Tech Tuesday Tips is an eBook you need. You can get it right here.Free Technology For Teachers, google forms, Google Sheets, Google Workspace, Google Workspace for Edu, how toRead More

Print page
0 Likes
No Comments

Sorry, the comment form is closed at this time.