google-sheets Examples and Free Source Code

Is there an alternative to onEdit(e)?...

google-sheets google-apps-script triggers

Fill in blank cells in ={ARRAYFORMULA()}...

if-statement google-sheets vlookup array-formulas nested-if

How to add and highlight rows on input of particular column in Google Sheet...

google-sheets google-sheets-formula array-formulas google-sheets-query gs-vlookup

Looking for color codes of the default fill colors in Google Sheets...

google-sheets colors formatting hex conditional-formatting

Google Sheets not plotting (stacked column chart) all my series data...

google-sheets charts stacked-chart dynamic-chart-series

Need h‭elp understanding Google Sheets PERCENTIF...

google-sheets google-sheets-formula precision

How can I use the Google Sheets API to append some data to a new row in a Google Sheet?...

google-sheets automation google-api statistics chi-squared

How to cross-link two sheets?...

arrays google-sheets google-sheets-formula range circular-dependency

How can I combine two sheets in a Google Sheet, where each sheet has the same index but different co...

google-sheets

Evaluate a Google Sheets math expression with formula...

google-sheets sum google-sheets-formula multiplication google-query-language

Get the email address of a "people chip"?...

google-apps-script google-sheets google-sheets-api

Is there a way to simplify the multiselect query in the google sheets?...

google-sheets filter lambda reduce google-query-language

Google Apps Script - duplicate sheet along with its scripts...

google-sheets google-apps-script google-cloud-platform google-sheets-api google-apps-script-api

Conditional Formatting In an Array with Multiple Conditions Evaluated...

google-sheets

Mapping google sheets cell to google drive and retreiving the link...

javascript google-sheets google-apps-script

Fetch xlsx file from email and copy file...

google-apps-script google-sheets google-drive-api

Get the last non-empty cell in a column in Google Sheets...

google-sheets worksheet-function google-sheets-formula

how to search for a cell and grab the next cell data...

google-sheets filter vlookup sumifs google-query-language

Function to subtract using automatically added date in Google Sheets Script...

google-sheets google-apps-script

How to convert a date to a string in Google Sheets?...

google-sheets

How to Concatenate cells separated by comma when adjacent cell is checked (or is there an easier way...

google-sheets google-sheets-formula formula

Highlight cell if checkbox value is different between corresponding row numbers and column numbers...

google-sheets google-sheets-formula match conditional-formatting textjoin

How to retrieve the first row where the date is more recent than x...

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

Couple match in google sheet...

google-sheets google-sheets-formula array-formulas

Increasing "00x" in calc code based on 1st and 2nd half of every month?...

google-sheets

InlineImages error, how to find what is wrong? sending a picture of the spreadsheet...

google-sheets google-apps-script

Rolling 12 week average calculation...

google-sheets

Sheet formula for finding total score for cell with same name multiply by bias and array...

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

How to automate the exchange section when using google finance formula in google sheets?...

google-sheets

Sort values in google sheet such that the new column will be a new row...

google-sheets google-sheets-formula array-formulas