peterkappus/Google Spreadsheet Cheats.md

Created July 8, 2016 13:33

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/peterkappus/13cc3fe1778025e45683d619b9cf545b.js"></script>
Save peterkappus/13cc3fe1778025e45683d619b9cf545b to your computer and use it in GitHub Desktop.

Download ZIP

Some handy tidbits for working with Google Spreadsheets

Raw

Google Spreadsheet Cheats.md

Select rows within a date range using an import range statement.

=query(importrange("https://docs.google.com/spreadsheets/d/<PEOPLE_DATABASE>/edit#gid=1208515556","CS People Database!A:Z"),"SELECT * WHERE Col6 = TRUE AND Col14 > date '" & text(E1,"yyyy-MM-dd") &"' AND Col14 < date '" & text(G1,"yyyy-MM-dd") &"' Order by Col14")