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.

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

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

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

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