Reversing the Order of Responses on Google Forms

Want your newest Form submission to appear on the TOP row of your Google Form instead of the bottom?

First: Go to your "Responses" spreadsheet.



Second: Freeze row 1 if you haven't already: View - Freeze Row - Freeze 1 Row



Third: Create a new tab by selecting the "+" button in the lower left corner of the spreadsheet.



Fourth: Select your new tab.



Fifth: In the A1 cell of this new tab, paste this code: =sort('Student Submissions'!A:C,1,0)




Sixth: Replace 'Student Submissions' with the name of your original tab.
Seventh: Replace the C with the letter of your last column (D, E, F, etc) on your form.
Last: Hit Enter. 



Notes: You may get an error message, but keep at it - the new, reverse order will fill itself out on the new tab, and all new submissions will appear at the top of the spreadsheet. The original tab of your spreadsheet will still auto-fill with the newest submissions on the bottom, but now you can select your new tab and view your submissions in reverse order, with the newest on top.

*All credit goes to productforums.google.com for help determining the code!


Comments