google-sheets-formula Examples and Free Source Code

How do I make a column that compares whether the entry in the one column matches the entry in anothe...

regex if-statement google-sheets google-sheets-formula textjoin

Return a specific value 'Open' where days are between Monday - Friday and time is >=8:00 ...

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

Google sheets: Parse date from text...

regex date parsing google-sheets google-sheets-formula

How to use an if condition with vlookup?...

google-sheets google-sheets-formula vlookup

My formula is counting an ID that shares some characters with another ID [Google Sheets/Excel]...

excel google-sheets excel-formula google-sheets-formula spreadsheet

Google Sheet MATCH formula with multiple criteria always returns 1...

arrays google-sheets-formula match vlookup index-match

Is there a way to tweak this formula to make this work, even if the name doesn't 100% match? If ...

regex google-apps-script google-sheets google-sheets-formula conditional-formatting

Is it possible to get a google doc modified date within a google sheets or apps script?...

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

Convert non standard text to date using Appscript...

arrays date datetime timestamp google-sheets-formula

REGEXEXTRACT before a group of characters in google sheets...

arrays regex google-sheets indexing google-sheets-formula

ArrayFormula & Vlookup: exclude the current row from Vlookup range...

google-sheets google-sheets-formula

How to execute the function only when there is a specific value in another column...

if-statement google-sheets lambda import google-sheets-formula

Google Sheets: Find unique matches in two columns and transpose them to an array...

google-sheets google-sheets-formula

Conditional formatting matching text based on another sheet in Google Sheets...

google-sheets excel-formula google-sheets-formula match conditional-formatting

How to use dynamic array formula to filter and format data...

google-sheets google-sheets-formula spreadsheet

Take tabulated data with start and end dates and transpose to a roadmap view, with items aligned to ...

google-sheets google-sheets-formula

Google Sheets query to get sum of two columns...

google-sheets google-sheets-formula

Repeating sequence with leading zeros to make all values same length in Google Sheets...

if-statement lambda google-sheets-formula sequence flatten

Query is ignoring string (non numeric) value...

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

Query Importrange with concat - adding 2 of the returned columns together...

import google-sheets-formula transpose flatten google-query-language

how to find the minimum product of two rows...

google-sheets google-sheets-formula

Google Sheets revoke importrange permission...

google-sheets google-sheets-formula access-control

Search for a value in multiple columns and return value from Column A...

if-statement google-sheets match google-sheets-formula flatten

Formatting 3 column array in Google Sheets with unique counts...

google-sheets google-sheets-formula array-formulas

How can I combine a Google Sheets query formula with arrayFormula formulas?...

google-sheets lambda google-sheets-formula vlookup array-formulas

Plus Symbol in front of a phone number converts it into a formula...

arrays google-sheets replace google-sheets-formula find-replace

Automatically Combine Duplicate Value and Rank...

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

How to reference another range or cell as a string argument in query?...

arrays google-sheets filter google-sheets-formula google-query-language

How to Auto Fill Date Column (with +30days) form Another Date Column in Google Sheet...

google-sheets google-sheets-formula

Use ImportXML to import data from an API...

google-sheets xml-parsing google-sheets-formula