Tag Info

Hot answers tagged

2

It seems to be a known Firefox bug: https://bugzilla.mozilla.org/show_bug.cgi?id=948510 (Alas, it was opened more than year ago…)


2

Please try: =IMPORTXML("https://www.youtube.com/watch?v=j6RsJmelphk","//div[@class='watch-view-count']") which should return something like 97,000 (views for a Colin Farrell - Road to Hell video).


2

If your Duration is a string then something like: =(left(A2,2)+mid(A2,4,2)/60+right(A2,2)/3600)*B2 otherwise: =A2*B2*24 with the result formatted as Number.


2

I assume you only want to do this in a certain part of the spreadsheet, and that it's a one-off problem which you need to fix, not something you need to repeat. For this, the simplest approach is to find another area the same shape and size (perhaps in another worksheet), and not currently used. In each cell in that area, set the forumula to something like ...


2

As suggested in the comments, you can use the INDEX formula for that. Leaving the third parameter blank, allows for a complete row to be shown: INDEX(reference, [row], [column]) INDEX(callService("geocodingServices"), 2) I couldn't help thinking about the geocodingService you use. This is also possible from within Google Apps Script. First I had to ...


1

Select all your data including labels and insert a Line chart. Then in Chart Editor check Switch rows/columns, Use column A as headers and Use row 1 as labels:


1

Fill A1 red (normal fill) and apply a Conditional formatting rule of Custom formula is : =counta(B1:B7)=7 with green Background Colour and Range: A1


1

The Conditional Formatting rules can accomplish that. Result: Rules:


1

That’s because the respective help page is referring to Google Docs (the text editor), not Google Sheets. And you are trying to insert it in a Google Sheets document.


1

With a help from a friend, he was able to create the following JavaScript which was imported into Google Sheets' Script Editor and then referenced as =PlanarPolygonAreaMeters2(A1,B1,C1)/1000000 var radiansPerDegree = Math.PI / 180.0; var degreesPerRadian = 180.0 / Math.PI; var earthRadiusMeters = 6367460.0; var metersPerDegree = 2.0 * Math.PI * ...


1

The only way I know is to use a 'dummy' parameter to the function, that is not really used in the custom function, but will trigger the function to recalculate. So, where you would normally use: =sumWhereBackgroundColorIs(color, rangeSpecification) you would now use sumWhereBackgroundColorIs(color, rangeSpecification, F1) In F1 (or any other cell you ...



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