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.