Tuesday, November 15, 2016

Forms Data Collection...Reverse The Order

I am not a fan of Google forms collecting data by putting the newest entries at the bottom. I often reuse forms with my students (I have some that I’ve been using since 2012) and can’t stand having to scroll to row 750 to find today’s entries. However, if you create a second tab in the spreadsheet and plop a simple formula in cell A2...all can be fixed. The formula pulls from the original data entry tab. So, if you make sure that tab is named “ENTRY”, just use the following formula in cell A2 of the new tab and you’ll be good to go: =SORT(ENTRY!A2:H,1,FALSE)

The only thing you’ll really need to pay attention to are the items in red. 1. “ENTRY” needs to match up with the exact name of the original data collection tab. 2. “A2” is in fact the top left cell from which you want to start pulling data.  3. “H” is the furthest right column from which you want to pull data. Don’t put a number after “H” so that it will continue to pull data ALL THE WAY down column H, even as new entries come in.

No comments:

Post a Comment