Use this tag for Google Sheets questions that involve the use of spreadsheet formulas.
I'm trying to get this aggregate date comparison working, and I thought I understood the syntax, but it's clearly not …
google-sheets google-sheets-formulaI have cells with dates that are formatted in different ways (and too messy to re-format, also lots of data) …
string google-sheets count wildcard google-sheets-formulaI'm trying to look at all cells in a set of columns/cells to count how many of them contain …
google-sheets google-sheets-formulaI am using the following formula to extract the substring venue01 from column C, the problem is that when value …
google-sheets google-sheets-formulaHow can I escape an apostrophe inside a SQL query in Google Sheets? Here's my function: =QUERY(QUERY(IMPORTRANGE("XXXXXXX", "…
google-sheets google-sheets-formula google-query-languageI am trying to get all the text in a node for a following set and returning as one value (…
xpath google-sheets xml-parsing google-sheets-formula google-sheets-importxmlIn Google Sheets, I want to filter view my results so only rows with an "x" in column D AND/…
filter google-sheets google-sheets-formula google-sheets-query google-query-languageHow can I add values in columns (T,U,V) and put the result in each adjacent cell in column …
google-sheets sum google-sheets-formulaI'm using ImportXML in a Google Spreadsheet to access the user_timeline method in the Twitter API. I'd like to …
xpath google-sheets google-sheets-formula google-sheets-importxmlI'm trying to summarize data from several Google spreadsheet' sheets in a single one but I have some issues with …
google-sheets google-sheets-formula sumifs