Friday, January 6, 2023

How to Sort Microsoft Forms Entries by Completion Time

A couple of days ago I helped a reader who needed a quick way to sort Google Forms responses so that the most recent submission was always easy to find. I'm guessing that there's probably a Microsoft Forms user out there who would like to know how to do a similar thing. That's why I created this short tutorial video. In the video that is embedded below you can see how to sort responses to Microsoft Forms according to most recent submission. 

Video - How to Quickly Sort Microsoft Forms Responses by Completion Time

Applications for Education
Sorting the Google Sheet attached to a Google Form is something that I've done for years. The same can be done with Microsoft Forms and Excel. 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.