google-sheets-formula tutorials

How can I force a recalculation of cell using ImportRange function in a Google Spreadsheet?

Oct 08, 2022

How to create INDIRECT array string of multiple sheet references in Google Sheets?

Nov 04, 2022

google-apps-script google-sheets google-sheets-formula array-formulas google-sheets-query

ImportRange Function to Ignore Empty Cells

Aug 28, 2022

google-sheets google-sheets-formula google-sheets-query google-query-language importrange

In ARRAY_LITERAL, an Array Literal was missing values for one or more rows - indirect formula error in google spreadsheet

Apr 01, 2022

google-sheets google-sheets-formula array-formulas

SELECT DISTINCT for only one Column in Google Sheets Query

May 22, 2022

sorting google-sheets filter google-sheets-formula google-sheets-query

Spreadsheet formula to gather all matches into one cell

Oct 29, 2022

google-sheets google-sheets-formula array-formulas

How to find nearest non-blank cell above the current cell?

Oct 26, 2022

google-sheets google-sheets-formula

Google Query - "NOT LIKE" Statement Doesn't work

Oct 22, 2022

sql google-sheets google-sheets-formula google-query-language

VLOOKUP within IMPORTRANGE

May 13, 2022

google-sheets google-sheets-formula google-sheets-query gs-vlookup importrange

Convert numbers in Google Sheets to Text / Words

Jul 16, 2022

google-apps-script google-sheets google-sheets-formula

Possible to use Google Spreadsheet functions in Google App Script?

Nov 05, 2022

google-apps-script google-sheets google-sheets-formula google-finance

Is it possible to set a default value of zero when using COUNTA function in Google Sheets?

Sep 24, 2022

google-sheets google-sheets-formula array-formulas

Google finance as an argument for ArrayFormula

Sep 19, 2022

google-apps-script google-sheets google-sheets-formula array-formulas google-finance

Multiple criteria for sumif in Google Sheets

Oct 22, 2022

google-sheets google-sheets-formula array-formulas

Google Sheets filename in cell via formula instead of a script?

Aug 27, 2022

function google-apps-script google-sheets scripting google-sheets-formula

Sum values of columns into adjacent column

Nov 05, 2022

google-sheets sum google-sheets-formula

How to get font color of cell in Google Sheets?

Sep 15, 2022

google-apps-script google-sheets google-sheets-formula

Is there a Google Sheets or MS Excel formula to convert a column with JSON array to multiple rows

Jul 02, 2022

json regex google-sheets google-sheets-formula array-formulas

New posts in google-sheets-formula