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.

 

 

About the blogger: Sean Crevier started teaching business classes at Vernon Hills H.S. in 2000, after leaving the technology consulting world. He currently wears three hats at VHHS; teaching business, working with other teachers as a technology integration specialist, and coaching golf. Sean serves on the ACTE Bylaws Committee and also works on the National Accounting Curriculum Team (accountingpilot.com), training teachers on implementing college accounting curriculum into their high school courses. Sean has given several educational keynotes, workshops, and a TED talk, is the co-founder of the bi-weekly #BusEdu chat on twitter, and loves learning with other educators. He is an outdoor enthusiast, Chicagoland native, Purdue Boilermaker, die hard Packer fan, lives in Lindenhurst, IL with his wife and 2 kids, and fights through daily battles with his “Only Child Syndrome”.. Connect with him on Twitter at @BusEdCrev or at busedcrev.blogspot.com.

This blog post was relaunched on mbea-ma.org with permission from the blogger. You may find the original post HERE.

➤