Search code examples
Match arrays to return one or more columns in Google Sheets...


google-sheetsgoogle-sheets-formula

Read More
Transform a calendar of tasks (table) into an actionable monthly task list...


google-sheetsgoogle-sheets-formula

Read More
How to copy a column based on value in two other columns to another column on the same sheet with Go...


google-sheetsgoogle-apps-script

Read More
How to copy a column if adjacent column does not contain a particular value to another column on the...


google-sheetsgoogle-apps-script

Read More
Unable to filter and sort multiple columns with this filter/sort/map function?...


google-sheets

Read More
How to automatically import data from uploaded CSV or XLS file into Google Sheets...


google-apps-scriptgoogle-sheetsgoogle-drive-apigoogle-sheets-api

Read More
Python gspread - loop through rows - update a cell with the sum or difference of other two cells in ...


pythongoogle-sheetsgspread

Read More
Based on a given date range, find the period "Period Beginning Date" for a given date outs...


google-sheets

Read More
How to get last Sunday's date?...


dategoogle-sheetsgoogle-sheets-formulaarray-formulasweekday

Read More
Trying to Color code Sparkline bar graph in Google sheets but getting unexpected errors...


google-sheetsgoogle-sheets-formula

Read More
How to set a Google Sheets' Cell Note based off a Cell Value that begins with a Plus Sign...


javascriptgoogle-sheetstriggers

Read More
Fill out empty cells in google sheet under a condition...


google-sheetsgoogle-sheets-formula

Read More
Python gspread formatting - Set vertical alignment to middle for range of cells...


pythongoogle-sheetsgspreadgspread-formatting

Read More
Google Sheets - Conditional Formatting between 2 or more cells...


google-sheetsconditional-formatting

Read More
How do you separate comma separated values in different columns while maintaining values in the rest...


csvgoogle-sheetsgoogle-sheets-formula

Read More
How do I reference an outside cell in a query?...


google-sheetsgoogle-sheets-formula

Read More
Can I get video statistics with the YouTube API?...


google-sheetsgoogle-apps-scriptyoutubeyoutube-api

Read More
Splitting a string to all it's characters...


google-sheetssplitgoogle-sheets-formula

Read More
Google Sheets 2 cells with identical functions, one is true, one is false; why?...


google-sheetsgoogle-sheets-formula

Read More
How to return the value of the last non-blank cell in a row? And the average of the last three?...


google-sheetsgoogle-sheets-formula

Read More
Google Sheets: Repeat "Product SKUs" for 5 rows per SKU in another Sheet...


google-sheetslambdasplittransposeflatten

Read More
View PDF file that is saved in Google Drive using Google App Script on Google Sheets...


google-sheetsgoogle-apps-scriptpdf

Read More
Lookup a value (in column) based on "Accumulated Sum" (or total) of QTY shipped column...


google-sheetsgoogle-sheets-formulavlookupaccumulate

Read More
Google sheets unique a list WITHOUT blank cells AND specific texts...


google-sheetsgoogle-sheets-formula

Read More
How to add +1 to a value when another cell has a specific value?...


google-sheetsgoogle-sheets-formulamaxifs

Read More
Flatten only non empty cells refrence range once...


arraysgoogle-sheetsflatten

Read More
How to highlight a row by looping column values via conditional formatting...


google-sheetsgoogle-sheets-formulaspreadsheetconditional-formatting

Read More
Change document orientation when exporting to PDF...


pdfgoogle-apps-scriptgoogle-sheets

Read More
Using data validation (drop down) with Query...


google-sheetsgoogle-sheets-formula

Read More
Populate dates based on frequency...


google-sheetsgoogle-sheets-formula

Read More
BackNext