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!
How to configure Conga Composer in a Salesforce Experience Site
Everything I learned the hard way about setting up Conga Composer in a Salesforce Experience Site (fka Community Cloud).
5 special properties of Microsoft Word for Mail Merge projects
Formatting tips for complex Mail Merge templates in Microsoft Word including conditional logic, hidden text, controlling page breaks, and more!
proof that math nerds make great civil rights activists
Learn about blueberry pie, the Birmingham Childrens' Crusade, and underrepresented people in STEM in this blog post on Dr. Freeman A. Hrabowski.
the case against Contact Record Types in Salesforce
Record Types are great for many Standard and Custom Objects in Salesforce. But, leave them alone for Contacts!
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.
Building a “smart” contact info collection form
How to create a "New Contact" form for staff and volunteers to fill out, while checking for duplicates!
I’m learning FlossCross!
I offer a post that's not about Salesforce, it's not about nonprofits, it's not even about spreadsheets (well, in a way it sort of is... but then again EVERYTHING is). It's about crafting, and coping, and playing, even in the worst of times.