Feb 1, 20221 min readAll of My Best Formulas in One PlaceI call this file my "Cheat Sheets Formula Repository". It's where I dump all of my favorite Google Sheets formulas. I use this daily.
Dec 1, 20212 min read3 Ways to Safeguard Your Google SheetIf you are building tools for use by an organization or online audience, you need to know how to 1) protect tabs; 2) auto-copy; and 3)...
Sep 1, 20213 min read6 Google Sheets Formula TricksSix of my favorite Sheets formula tricks. Hopefully these will save you some time… and some headaches.
Jul 1, 20211 min readList of Commonly Used Characters to Insert into Your Sheets FormulasUse this reference list to easily insert arrows, smiley faces, check marks etc. into your formulas. You're welcome. The "CHAR" function...
Mar 1, 20212 min readHow to Flatten Survey Data in Google SheetsThis sequence of steps lets you easily “flatten” a data set in Google Sheets, by organizing matrixed data into simple objects and fields