Milton SlonimSwitch Buttons on Google sheetsInspired by this article by Ben Collins, I decided to make my own version of Radio Buttons in Google sheets, more similar to the ones we…Apr 10, 2022Apr 10, 2022
Milton SlonimAdvanced VLOOKUP — Google sheetsHow to maximize one of the most powerful formulasFeb 20, 2022Feb 20, 2022
Milton SlonimClean Code for Google sheets: Advanced tipsIn software development there is a very useful concept called “Clean Code”, introduced by “Uncle Bob” in his book.Nov 20, 2021Nov 20, 2021
Milton SlonimHow to create queries based on column name — Google sheetsDo you sometimes find that when you have to use the =QUERY() formula and the data is on another sheet, you have to go from one sheet to…Sep 12, 2021Sep 12, 2021
Milton SlonimHow to create a form with Google sheets + Apps scriptLet’s suppose you have this database:Sep 6, 2021Sep 6, 2021