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 literally use this tool every day.
One Google Sheets file to rule them all?
Every time I create or come across a Sheets formula that I like and is complex enough that I don't feel like memorizing it, I add it to this doc:
Link: Cheat Sheets Formula Repository
As you'll see, for each formula, I include a description, an in-context example and a link to the blog post where I discuss it, if there is one.
My suggestion: add this to your browser's Favorites. I'll continue to update it regularly, so hold to it.
Hope it's helpful!