Use this tag for Google Sheets questions that involve the use of spreadsheet formulas.
I'm using Google Sheets for a daily dashboard. What I need is to change the background color of cell B5 …
google-sheets google-sheets-formula gs-conditional-formattingI want to count the cells that contain anything within a range. Any cell that contain text, or numbers or …
google-sheets google-sheets-formulaI use the following function =DAYS360(A2, A35) to calculate the difference between two dates in my column. However, the …
google-sheets worksheet-function google-sheets-formulaIn a Google Spreadsheet: How can I count the rows of a given area that have a value? All hints …
google-sheets google-sheets-formulaI'm trying to recode all the zip code from Column A into Column B with the formula: =TEXT(A1,"00000") Like …
google-sheets array-formulas google-sheets-formulaWhat would be a good approach to calculate the number of occurrences in a spreadsheet column? Can this be done …
google-sheets google-sheets-formula array-formulasI'm trying to set up a formula with multiple IF statements between number ranges but I'm seeing the error: Formula …
if-statement google-sheets google-sheets-formulaI have a spreadsheet with some values in column G. Some cells are empty in between, and I need to …
google-apps-script google-sheets google-sheets-formula array-formulas custom-functionSo I'm stuck with something. I have two spreadsheets, column A on each are similar but not identical, some values …
google-sheets google-sheets-formula gs-vlookupI want to union ranges from any Google spreadsheets. The example Sheet1!A:A {12, 131, 45} Sheet2!A:A {12, 131, 46} The unknown function =…
arrays google-apps-script google-sheets google-sheets-formula