Use this tag for questions about interacting with Google Sheets programmatically.
In Google Sheets I need to reference a cell by (column, row) in a way where I can replace "row" …
google-sheets referenceI am looking for a way to automatically change the color of the minimum cell in a row in Google …
google-sheets gs-conditional-formattingI'm doing this query at my google spreadsheet: =QUERY(H4:L35;"select sum(L) where H='First Week'"; -1) But …
google-sheets formulas google-sheets-query google-query-languageI want to input a variable in a cell only if the cell is empty. The if statement, however, does …
google-apps-script google-sheets cell spreadsheetI use the SPLIT function to split a string which looks something like 1.23/1.15. Right now it yields two cells, as …
google-sheets google-docsI need to convert a Google Spreadsheet column index into its corresponding letter value, for example, given a spreadsheet: I …
javascript google-apps-script indexing google-sheetsThis question is concerning joining two databases in Google spreadsheet using =QUERY function I have a table like so in …
sql google-sheets google-query-languageI have a range of cells selected in a Google Sheets (activerange). I want to iterate over every cell in …
google-apps-script google-sheetsI am using Google SpreadSheet, and I'm trying to have multiple sheets containg a list of words. On the final …
google-sheetsIn Google Spreadsheets, I need to use the COUNTIF function on a range with multiple criteria. So in the table …
regex google-sheets countif google-sheets-formula array-formulas