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.5 min read·May 5, 2024----
Max MakhrovAddon Series Part 4: 🏃🏼♀️Running Apps Script in Parallel from HTMLHi, I’m Max from CoolTables.6 min read·Feb 28, 2024----
Max MakhrovGoogle Sheets [🔧Fixed]. Prevent users from deleting formulasHi, this is Max from CoolTables.7 min read·Oct 31, 2023--1--1
Max MakhrovGoogle Sheets [🔧Fixed] Prevent users from pasting over cells with data validation (Dropdowns)Fix broken data validations in case user overwrites cells.3 min read·Oct 20, 2023----
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.1 min read·Sep 26, 2023----
Max MakhrovGoogle Apps Script ➡️ Utils. Create folders and copy files fast⚡This article is a try to adopt the library written by Tanaike:5 min read·Sep 8, 2023--1--1
Max MakhrovGoogle Apps Script ➡️ Utils. Get or find a folder by name and create a new if not existThe code here is the part of “Utils” project on GitHub.3 min read·Sep 6, 2023----
Max Makhrov5 STEPS to Deploy Google Sheets External Editors add-onWe deploy an add-on that lives in Spreadsheet — editor add-on. More here:5 min read·Sep 5, 2023----
Max MakhrovNamed function📜 for Google Sheets. Trim Chars — Replace selected chars from a stringIf you have some manually entered text in a column, and wish to clean it from unneeded chars, use this named function:1 min read·Aug 11, 2023----
Max MakhrovGoogle Sheets [🔧Fixed] #REF Error. Array result was not expanded because it would overwrite data…Original post3 min read·Aug 11, 2023----