Use this tag for Google Sheets questions that involve the use of spreadsheet formulas.
I would like to aggregate the data of multiple spreadsheets into one spreadsheet. Spreadsheet 1 has a Row of Strings A2:…
google-sheets google-sheets-formula array-formulas importrangeI'm trying this function on Google spreadsheet without success in order to gather in a sheet a value after a …
google-sheets google-sheets-formula google-sheets-query gs-vlookup importrangeMy IMPORTRANGE function is not refreshing with new data once the linked spreadsheet is added to. Instead, I am having …
google-apps-script google-sheets google-forms importrangeWhen you enter an importrange function manually into a spreadsheet you receive a pop up and must 'allow access'. However, …
javascript google-apps-script google-sheets importrangeI 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 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