Max MakhrovGoogle Sheets Add-on. From idea to MVP (Story in pictures)September 2024. Now I have an add-on in closed beta.Sep 12Sep 12
Max MakhrovGantt Chart on Dependencies with Recursion in Google Sheets. Part 1Our goal is a GANTT chart in Sheets based on dependencies.Jun 21Jun 21
Max Makhrov6 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 17Jun 17
Max MakhrovEvolution 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 101Jun 101
Max MakhrovGoogle 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 5May 5
Max MakhrovAddon Series Part 4: 🏃🏼♀️Running Apps Script in Parallel from HTMLHi, I’m Max from CoolTables.Feb 28Feb 28
Max MakhrovGoogle Sheets [🔧Fixed]. Prevent users from deleting formulasHi, this is Max from CoolTables.Oct 31, 20231Oct 31, 20231
Max MakhrovGoogle 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
Max MakhrovGoogle Apps Script ➡️ Utils. Allow all IMPORTRANGE formulas for a given SpreadsheetHere is the Apps Script code to open access to all importrange formulas in a given Google Spreadsheet.Sep 26, 2023Sep 26, 2023
![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)
