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.

IMPORTRANGE is what allows your Google Sheets files to talk to each other. Here are two tips to improve that talk.

Filter a range if a match is found within a (maybe long?) list of options. Or don't. I don't care.

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

My buddy sent me this trick under the subject line “MIC DROP”. To his credit... it's pretty damn good. Beautiful, easy Gantt charts

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

Return a range sorted by data in a different column. Examples include a Sales Scoreboard and a prioritized Action Item List

Use this Query function to clean a list of emails by subdomain. A good alternative to expensive “bounce rate reduction" softwares

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

A cleaner method to assign tiers or cohorts. Examples include: Assigning hospitals to size tiers; 2) placing users in signup cohorts