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.
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!
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!
Everything I learned the hard way about setting up Conga Composer in a Salesforce Experience Site (fka Community Cloud).
Record Types are great for many Standard and Custom Objects in Salesforce. But, leave them alone for Contacts!
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.
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.
Shoutout to adrienne maree brown, and to all of you who sent me her spreadsheet post!
I used formulas, text variables, collection variables, loops, and assignments in Salesforce Flow to compare lists of Contacts and Contact Roles and create new Contact Roles as needed. Read further for the first attempt that didn't work... and how I fixed it!
Lessons from UAT... and Taylor Swift gifs sprinkled throughout!