Hot answers tagged

3

You can use the HYPERLINK function. Then you can click the image, and see it in a new tab. For the you tab you can save / download / export or whatever you want. Example Function =HYPERLINK("http://www.abc.net.au/news/image/7650580-3x2-340x227.jpg",IMAGE("http://www.abc.net.au/news/image/7650580-3x2-340x227.jpg"))


1

The necessary changes are: replace onEdit with onOpen, and eliminate the check if( activeCell == "K2" ) as the script is no longer about the active cell. I also shortened the script by replacing the inner conditional statement with a ternary operator. function onOpen() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var mysheet = ss.getSheetByName("...


1

This can be done with query as follows: =query({index(B1:Z10, 2, 3)}, "select * where Col1 <> '"&A1&"'", 0) The query string means "select all where column 1 of the queried array is not equal to the content of cell A1". The curly braces around index are there to make it possible to refer to the column as "Col1", without knowing whether it's ...


1

There are multiple ways to handle this. One solution is to keep the input sheet down to one row with data, overwriting old data in Row 2 daily. Then the built-in spreadsheet functions can handle splitting: =transpose(split(rept(A2&",", B2), ",")) creates a column with the date in A2 repeated the number of times indicated in B2; and =transpose(split(...


1

Stepped area chart does not support variable width of steps. But you can use the ordinary area chart like this: The data provided to this chart was as follows. The first column was marked for "use as labels" when inserting the chart. 0.00 0 1.00 0 1.00 1 1.41 1 1.41 2 1.73 2 1.73 3 2.00 3 2.00 4 2.24 4 2.24 5 2.45 5 2....


1

There is a difference between the string of characters "100103" and the number 100103. Your workshops tab contains numbers. regexextract returns a string. To make things work, convert string to number using value after regexextract: =arrayformula(iferror(value(regexextract(regexextract(F2:F, "ID#\d+"), "\d+"))))


1

Yes, this can be done. Following I will show an approach that use the running total formula posted by AdamL but first, it prepares the input data to be used by the referred formula: First sort the input range in inverse order C1: =SORT({{A3:B7},ROW(A3:A7)},3,FALSE) Calculate the running sum for the first (key) column F1: =ArrayFormula(SUMIF(...


1

Instead of switching back to the old Google Sheet version, one can simply add the add-on of the plug-in needed (for e.g. Google Analytics) and can create, run or schedule a report from the Add-ons menu option.



Only top voted, non community-wiki answers of a minimum length are eligible