YOUR EVERYDAY GOOGLE SHEETS TOOLKITDo more with
Do more with
Google Sheets.
Turn “how do I do this?” into done. Practical tutorials, formulas, and shortcuts for the work on your screen.
team-directoryEXAMPLE SHEET
▦A little formula. A clear answer.↗
ƒx
=FILTER(A2:C5, B2:B5="Sales")ABC
1NameTeamLocation
2MayaSalesLondon
3JordanDesignAustin
4AlexSalesToronto
5SamFinanceBoston
+ Team directory ▾2 matching rows
Just the rows you need.One formula. No manual sorting.
What’s on your sheet today?
Make the repetitive
parts automatic.
Get to know Google Apps Script and what it can do for your sheets.
Explore Apps Script ↗