In this post, I write about multi select drop down menus in Google Sheets, how to automate creating spreadsheets, and when automation might not make sense.
DIY Google Classroom with Zapier for Mr. Spreadsheet Whisperer
When Mr. Spreadsheet Whisperer is having trouble copying Google Files into folders for each camper, what should he do? Use automation to process repetitive, tedious tasks!
Dear Spreadsheet Whisperer: How to Build a Tax Prep Friendly Expense Tracker in Google Sheets
In this installment of Dear Spreadsheet Whisperer, "Frustrated Finance Freelancer" looks for support about how to track business expenses. We cover multiple ideas, including Pivot Tables and Filter formulas in Google Sheets.
Dear Spreadsheet Whisperer: Or Else?
What should a social justice movement leader do when his spreadsheets aren't behaving properly? Email the Spreadsheet Whisperer, of course!
How to compare addresses
StreetStStrSt.AvenueAveAve. How many different ways can you write an address? Turns out... a LOT. Typically, when I am cleaning address data (yes, that's something I do quite regularly, what with being a spreadsheet whisperer and all), I am preparing to either (1) upload a single file into an online database or (2) create a mail … Continue reading How to compare addresses
Dear Spreadsheet Whisperer: Date Me?
What do my partner, date field formulas, and the Chicks have in common? Read this post to find out! Especially if you create time sheet systems to manage your workload!
Dear Spreadsheet Whisperer: Tzedakah Tsuris
What to do when you outgrow your grassroots spreadsheet systems? Try Airtable! It's flexible, freemium, and fun to use. Oh, and this is #NotAnAd!
Dear Spreadsheet Whisperer: Gettin’ Schooled
In this edition of Dear Spreadsheet Whisperer, lessons about how to set up spreadsheets to ask hard questions about racial equity in schools.
Dear Spreadsheet Whisperer: capital-O Organizing
What's the best way to use a database for distributed organizing? Can Salesforce even do this? Plus, beautiful, custom watercolor illustrations from the one and only Katie Blanchard.
smol, medium, large
Not knowing if a given scenario is easy or hard, or if there's an easier work-around to avoid a super-hard thing, feeds the overwhelm/impostor machine. It's so clarifying and liberating to just know what you're getting yourself into. PLUS, baby animal memes!