Hey Education Friends!
Some of you have asked how to make Google Sheets move your most recent Google Form responses to the top of your spreadsheet. This would be particularly helpful in conjunction with our Attendance Forms training.
1. Open a new tab
2. Copy/Paste your column titles from your responses tab into row 1 of Sheet 2
3. Click on A2 of Sheet 2
3. Copy/Paste the following link into A2:
=SORT('Form Responses 1'!A2:Z,1,FALSE)
VOILA!!
This video walks you through the steps.
No comments:
Post a Comment
Did you find this blog helpful? Do you have any specific topics you'd like covered? I'd love to hear from you!
And please...
In a world full of so much darkness, be the light!