google-sheets

Google spreadsheet direct download link for only ONE sheet as excel

by

You can download a specific sheet using the ‘GID’. Each sheet has a GID, you can find GID of specific sheet in the URL of spreadsheet. Then you can use this link to download specific sheet – https://docs.google.com/spreadsheets/d/<KEY>/export?format=xlsx&gid=<GID> ex: https://docs.google.com/spreadsheets/d/1D5vzPaOJOx402RAEF41235qQTOs28_M51ee5glzPzj0/export?format=xlsx&gid=1990092150 KEY is the unique ID of the spreadsheet. source: https://www.quora.com/How-do-I-download-just-one-sheet-from-google-spreadsheet/answer/Ranjith-Kumar-339?srid=2YCg

In Google sheets, how does one either return a blank cell or perform a function based on another cells lack of content?

by

If you want to end up with a truly ‘blank’ value, you can use the expression IFERROR(0/0). This is different from an empty string which is what you get when you use “”. A cell with an empty string will not test true using ISBLANK(), but IFERROR(0/0) will. For example: =IF(ISBLANK(A1),IFERROR(0/0),”not blank”) How this works: … Read more

How to use GOOGLEFINANCE((“CURRENCY:EURAUD”)) function

by

The specific instructions for what you are looking for are in here: https://support.google.com/docs/answer/3093281 Remember your Google Spreadsheets Formulas might use semicolon (;) instead of comma (,) depending on Regional Settings. Once made the replacement on some examples would look like this: =GoogleFinance(“CURRENCY:USDEUR”) =INDEX(GoogleFinance(“USDEUR”,”price”,today()-30,TODAY()),2,2) =SPARKLINE(GoogleFinance(“USDEUR”,”price”,today()-30,today())) Those 3 cells would result in something like this (the second … Read more

Is it possible to automate Google Spreadsheets Scripts (e.g. without an event to trigger them)?

by

Now it is possible to add time based events. from: http://code.google.com/googleapps/appsscript/guide_events.html Edit -> Current project’s triggers. You see a panel with the message No triggers set up. Click here to add one now. Click the link. Under Run, select the function you want executed on schedule. Under Events, select Time-driven. On the first drop-down list … Read more