Google Sheets | Cooltables

Dynamic Table of Contents for Google Sheets: Easy Search, Color Filter, & Real-Time Updates

Google Sheets In-Cell Donut Charts: Easy Auto-Updating Chart Formula Tutorial

Live Animated Summer Olympics Gold Medal Stats in Google Sheets

Google Sheets Formula to Automate Hundreds of Outlined & Filled Bar Charts

How to transfer Google Sheet to BigQuery (in 4 clicks)

How to load JSON array to BigQuery

CHART with rounded corners in Googe Sheets

Ultimate Beginner's Guide to Google Sheets

🎓Teachers Book. Accounting system for tutors in Google Spreadsheet

Google Sheets Project. Convert Selection to PNG Image

Google Sheets vs GitHub

Use Google Form as custom HTML-interface for Sheets

Get 90 AI-generated fake Faces into your Google Sheets

SheetJobs. Copy files from one folder to another. Script

How to SPLIT text by text as text in Google Sheets

#13. Working with Text. Extract Numbers

🐞 Work with delimited text in Google Sheets. ArrayFormulas.

#3. Working with Text. Number of times certain text occurs

How to convert digits to emojies with SEQUENCE+ in Google Sheets

How to create sequence of repeated values in Google Sheets. 111-222-333...

Basics#3. Cells and Ranges #3. Your first script: Find the cell

Basics#28. Filter #6. Contains in list

SheetSpam#18. Get Sheet by name with function in Google Script

Filter Out All Blank Rows with a formula in Google Sheets

Create folders in Drive automatically with Google Sheets Script

How to Enable/Disable Filter criterias with a CheckBox in Google Sheets

How to install named functions to your Google Sheets → 🪅function for blank rows below each group

CoolTables.Online Collection of Named Functions for Google Sheets

How to combine (merge/union) ranges with FILTER function in Google Sheets

How to split text by chars in Google Sheets. Bonus: most emojis are splitted correctly 😉

How to zoom in out fast in

Import XML Data to List My WordPress Posts in Google Sheets

SheetJobs. Clear Ranges. Script

How to paint your cell with Colors function in Google Sheets

Sheet-Jobs. Copy multiple sheets automatically with a script

How to mockup your dataset with distributed random pick function in Google Sheets

How to generate array by row indexes in Google Sheets. ArrayFormula

Unlock the Secret to Mastering Gantt Charts in Minutes!

How to create random dates chain in Google Sheets

SheetSpam#26. Filter with a script in Google Sheets Script

How to create a list of random emails in Google Sheets with Lambda function + ByRow

Untitled spreadsheet Google Sheets Google Chrome 28 October 2022

SheetSpam#29. Create Reference with Unique formula in Google Sheets

SheetSpam#12. Open Script Editor in Google Sheets

How to generate array of columns by column indexes in Google Sheets. ArrayFormula

Filter by Text with a Function in Google Sheets

How to FILTER by Alphabet in Google Sheets

SheetSpam#27. filter and paste values in Google Script. Algorythm

#14. Working with Text. Replace multiple text

Emailer. Send emails automatically from Google Sheets

How to get country flags images into your Google Sheets. ArrayFormula

How to count items by groups in a sorted data in Google Sheets.

SheetSpam#16. Autocomplete the code in Google Sheets Script

ImportRange ArrayFormula in Google Sheets. Lambda+ByRow

Basics#1. Cells and Ranges #1. How to find exact rows and columns

SheetSpam#13. Get Range Data in Google Sheets Script

🍿 Last Chunk of delinited text in Google Sheets

Basics#21. RegEx #1. Extract Phone Number