Selecting the last value of a column
Similar answer to caligari’s answer, but we can tidy it up by just specifying the full column range: =INDEX(G2:G, COUNT(G2:G))
google-apps-script
Refresh data retrieved by a custom function in Google Sheet
Ok, it seems like my problem was that google behaves in a weird way – it doesn’t re-run the script as long as the script parameters are similar, it uses cached results from the previous runs. Hence it doesn’t re-connect to the API and doesn’t re-fetch the price, it simply returns the previous script result … Read more
How to get the correct range to set the value to a cell?
The following code does what is required function doTest() { SpreadsheetApp.getActiveSheet().getRange(‘F2’).setValue(‘Hello’); }
How to number the headings in a Google Docs/Drive document?
If you want something more easy, there is a Google Add-On called “Table of Contents” that will allow you to number your headings. To install this add-on: Click on the Add-Ons > Get Add-Ons. Click on the “Table of Contents” icon or search for this addon to install it Then your Table of Contents should … Read more