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.
How to calculate *conditional* Average, Median, and Mode in Google Sheets
Google Sheets offers an =AverageIF() formula, but what if you need =ModeIF() or =MedianIf()? Here's a post on how to solve this, and why it matters for social justice orgs.
Running a competitive application process in Salesforce, Google Sheets, and FormAssembly
What tech stack should we use for complex application forms for a flagship fellowship program? Here's one description of what I set up and what we learned!
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.
3 new-to-me spreadsheet capabilities (plus a bonus)
While analyzing survey data, I encountered 3 new spreadsheet capabilities in Excel and Google Sheets!
How to interpret survey data in Google Sheets with dynamic charts and drop down menus
Sorting through Google Form survey responses? What if I told you that you didn't have to rely on the auto charts from Google Forms, and instead, you could develop a fully automated, responsive, Google sheets dashboard for disaggregating data and drawing insights from the data? Here's how!
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!
I was wrong: tech mistakes, accountability, and trust
Report back from my session at #22NTC and what to do when we - inevitably - make mistakes on the way to good technology.
How to make Validation Rules into *Validating* Rules
The database world is replete with options for "validating" data, but there is a huge missing link in our field, which for me boils down to VALIDATING HUMANS.