🛢️How to Connect Google Sheets to BigQuery: A Simple GuideIn the world of AI, Google Sheets is still cool. It’s loved for its functions, easy sharing, and the wonder of Google App Script. But…Dec 10, 2024Dec 10, 2024
Google Sheets Add-on. From idea to MVP (Story in pictures)September 2024. Now I have an add-on in closed beta.Sep 12, 20241Sep 12, 20241
Gantt Chart on Dependencies with Recursion in Google Sheets. Part 1Our goal is a GANTT chart in Sheets based on dependencies.Jun 21, 2024Jun 21, 2024
6 reasons you should be using the LET function in Google Sheets.The LET function can have an amazing impact on your Google Sheets formulas.Jun 17, 2024Jun 17, 2024
Evolution of VLOOKUP in Google SheetsMost of us start with a simple VLOOKUP but as our needs evolve — the tables grow and our requirements grow with them.Jun 10, 20241Jun 10, 20241
Google Sheets FILTER with “IN” Logic: List Has Value from Master ListBenchmark 4 different approaches and select the best formula for your Google Sheets project.May 5, 2024May 5, 2024
Addon Series Part 4: 🏃🏼♀️Running Apps Script in Parallel from HTMLHi, I’m Max from CoolTables.Feb 28, 2024Feb 28, 2024
Google Sheets [🔧Fixed]. Prevent users from deleting formulasHi, this is Max from CoolTables.Oct 31, 20231Oct 31, 20231
Google Sheets [🔧Fixed] Prevent users from pasting over cells with data validation (Dropdowns)Fix broken data validations in case user overwrites cells.Oct 20, 20231Oct 20, 20231
![Google Sheets [🔧Fixed]. Prevent users from deleting formulas](https://miro.medium.com/v2/resize:fill:160:106/1*ield3WM8Erycoa-HOkjKCA.png)
![Google Sheets [🔧Fixed]. Prevent users from deleting formulas](https://miro.medium.com/v2/resize:fill:320:214/1*ield3WM8Erycoa-HOkjKCA.png)
![Google Sheets [🔧Fixed] Prevent users from pasting over cells with data validation (Dropdowns)](https://miro.medium.com/v2/da:true/resize:fill:160:106/1*XGML-tuiyP-LQQCPzr2wmw.gif)
![Google Sheets [🔧Fixed] Prevent users from pasting over cells with data validation (Dropdowns)](https://miro.medium.com/v2/da:true/resize:fill:320:214/1*XGML-tuiyP-LQQCPzr2wmw.gif)
