Use this tag for Google Sheets questions that involve the use of spreadsheet formulas.
I'm having trouble stopping the googlefinance function on a specific date to use "that" specific exchange rate to convert currency …
google-sheets currency google-sheets-formula google-financeI've got a spreadsheet which looks like this: A B C D FirstName SurnameName Address UniqueFamilyId --------------------------------------------------------- Abe Black 1 Elm …
google-sheets google-sheets-formula array-formulasI am trying to insert a hyperlink to a cell in a fashion that can be replicated using '=MATCH()" …
google-apps-script google-sheets hyperlink google-sheets-formula array-formulasThe GOOGLEFINANCE function in Google Sheets allows you to lookup the price (or other attribute) of a stock or instrument. …
regex google-sheets google-sheets-formula google-sheets-query google-financeAnyone know workarounds to make GoogleFinance actually work? It works for a while so it is not a problem with …
google-sheets nested google-sheets-formula google-financeI want to import a range from another Google sheet, but to ignore empty cells so that the data prints …
google-sheets google-sheets-formula google-sheets-query google-query-language importrangeI have (what I thought was) a simple lookup table holding some exchange rates. There I am looking up values …
google-sheets google-sheets-formula array-formulas gs-vlookupI have a huge list of items in Column A (1,000 items) and a smaller list of items in Column B (510 …
filter google-sheets google-sheets-formulaI have a spreadsheet Target that uses ImportRange to get some data from another spreadsheet Source, as in A6 = query(…
google-apps-script google-sheets google-sheets-formula importrangeI am currently working in the following spreadsheet https://docs.google.com/spreadsheets/d/13KfjUhWSB-BjGyC1G8f8i8o4SPd1…
google-sheets google-sheets-formula google-sheets-query google-query-language importrange