Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
google spreadsheet cheat sheet

exchange rate for a given day

=INDEX(GoogleFinance("usdeur","price",today()-1,today()),2,2)

import a cell or a range of cells into another document

=importRange("0AgQNm5fx5y30dG9ZTXNQbTFtaTlOaWFuZmdXeV81VHc","Sheet1!A1:B10")

or without sheet id:

=importRange("0AgQNm5fx5y30dG9ZTXNQbTFtaTlOaWFuZmdXeV81VHc","A1:B10")

or for a single cell:

=importRange("0AgQNm5fx5y30dG9ZTXNQbTFtaTlOaWFuZmdXeV81VHc","A1")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment