Other

All of My Best Formulas in One Place

I call this file my "Cheat Sheets Formula Repository". It's where I dump all of my favorite Google Sheets formulas. I use this daily.

3 Ways to Safeguard Your Google Sheet

If 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)...

6 Google Sheets Formula Tricks

Six of my favorite Sheets formula tricks. Hopefully these will save you some time… and some headaches.

List of Commonly Used Characters to Insert into Your Sheets Formulas

Use this reference list to easily insert arrows, smiley faces, check marks etc. into your formulas. You're welcome. The "CHAR" function...

How to Flatten Survey Data in Google Sheets

This sequence of steps lets you easily “flatten” a data set in Google Sheets, by organizing matrixed data into simple objects and fields