google-sheets-formula Examples and Free Source Code

Multiply Parameter exclude header row...

google-sheets lambda google-sheets-formula array-formulas google-finance

Simple way to choose random cell from a list in Google Sheets...

arrays google-sheets random indexing google-sheets-formula

Google Sheet - Defining Churn based on the set of criteria...

google-sheets google-sheets-formula spreadsheet saas

Google Sheets: How to auto split a data set in half to create a control and test group based on a co...

google-apps-script google-sheets lambda google-sheets-formula google-query-language

GOOGLE SHEETS - Arrayformula for duration between 2 datetime stamps ignoring weekends and our of hou...

if-statement google-sheets lambda nested-if google-sheets-formula

How to list data from another sheet depending on the date...

date google-sheets google-sheets-formula match google-query-language

Google Sheets IMPORTRANGE with cell variables...

google-sheets import concatenation google-sheets-formula textjoin

How to get Number of days between 2 dates when specific condition is met?...

date datetime google-sheets filter google-sheets-formula

How can I auto fill a formula with dynamic value in array in the same cell?...

arrays google-sheets lambda google-sheets-formula google-query-language

Query/filter out blank non-specified columns from range...

google-sheets filter google-sheets-formula is-empty dynamic-columns

Is it ArrayFormula I want?...

google-sheets google-sheets-formula

How to conditionally change a date based on a time? Time zone differences?...

google-sheets google-sheets-formula

How to get permutations from factoradic numbers without lambda as a array formula?...

google-sheets google-sheets-formula permutation factorial

Why comparing text in google sheets returns true and false?...

google-sheets google-sheets-formula

Checkboxes and dates...

date google-sheets lambda timestamp google-sheets-formula

The names of sheets are changed when users use different languages...

google-sheets google-sheets-formula

Data validation to Put values in column based on condition...

date validation if-statement google-sheets google-sheets-formula

Remove characters in Googlesheets...

google-sheets google-sheets-formula spreadsheet

Excel or Google Sheets—Is there a way to duplicate rows in place using only formulas?...

excel google-sheets lambda excel-formula google-sheets-formula

Formula to copy paste formulas from gsheets to SQL...

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

How do I insert data into sections with dividers in Google Sheets...

google-sheets google-sheets-formula google-sheets-api spreadsheet

Create a function that returns really nothing in Google Sheets...

google-sheets filter count google-sheets-formula divide-by-zero

How to maintain absolute cell address even when deleting ranges?...

arrays google-sheets google-sheets-formula google-forms delete-row

Defining something within an ArrayFormula which is then used in the ArrayFormula...

arrays google-sheets lambda google-sheets-formula array-formulas

How to check for the rows continuity of an event in Google Sheet...

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

How to iterate each cell of a range, NOT only the values, keeping the original index (row and column...

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

SUM multiple values after a substring within all cells in a column in Google Sheets...

regex google-sheets split google-sheets-formula re2

Regular expression that matches a pattern as well as any number of comma space separated repetitions...

regex google-sheets google-sheets-formula repeat re2

Google sheets - Query + Importrange WHERE Clause doesn't accept AND for a second condition...

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

Find Average Using Two Conditions (with Different Data Types, number of days and currency)...

google-sheets google-sheets-formula