Last week a reader reached out to me for some steering on easy methods to deal with a Google Form that had a couple of hundred submissions. He was in search of a strategy to rapidly discover essentially the most info submitted in the latest entries. My resolution to that downside was to make use of Z-A kind within the Google Sheet related to the Form. By doing that you will note the latest entry on the prime of the sheet.
In the video that’s embedded beneath I exhibit easy methods to type 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 connected to a Google Form is one thing that I’ve executed for years. I try this so when I’ve college students finishing one thing like a apply quiz over the course of per week I can rapidly discover the most recent submission and assessment it with a scholar with out having to continuously scroll to the underside of the sheet.
Learn rather more about Google Forms in this playlist of 40 Google Forms tutorials movies.