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.
DO Look Up! community review of DLRS Release 2.17
This post fangirls Declarative Lookup Rollup Summary, DLRS, pronounced duh-LOR-us, sort of like your old aunt Dolores. DLRS is a community-resourced app that extends functionality in Salesforce to have more "roll up" or min/max/count/average type fields, respecting relationships between objects. Learn more about DLRS here. Far before the provocative 2021 film, Don't Look Up, Salesforce … Continue reading DO Look Up! community review of DLRS Release 2.17
exposition on building a civil rights outcomes tracking database
Reading about the SCLC's impact in their voter registration efforts leads to a fantasy about how to build a database for civil rights metrics. Hats off to my personal hero, Jack O'Dell.
Steven Universe presents: Filter Views
Need to maintain multiple views of the same data? Learn about my "Filter Square Mindset" of applying Filter Views rather than Filters in Google Sheets! Plus, gifs, cartoons, puns, and more!
hide and seek
=IF(FIND(ers, keepers), "", "weepers"). In other words, using text functions to make sense of lists. Plus, gifs and my pet turtle, Prince!
breadcrumbs trail / matzo meal
I think it's a best practice to design ALL spreadsheets as if they will be manipulated by other people, which means leaving a strong "breadcrumbs trail" of your assumptions, formulas, variables, data sources, and more. In my case, it's a matzo meal trail until tomorrow evening when Passover ends and I will devour pizza with all my might!
lipstick on a pig
What do pigs, horses, donkeys, formulas, and tables have in common? Read more to find out, plus GIFs and best practices for formatting spreadsheets for optimum share-a-bility.
Reuse, Recycle, Retain your Volunteers
A challenge to calculate "Returning Volunteers" has me waxing poetic about re-gifting, digging deep into the Meme Stache, and writing some gnarly formulas. Join me!
encountering a real, live Excel bug
I think I stumbled upon an Excel "bug" (gasp!!) when I was combining SUMIF formulas plus sorting alphabetically. @___@ This is a new one, grasshoppers and honeybees! Sit down, buckle in, and enjoy the ride - we're gonna get technical with some formulas and explore what to do when you get real confused.
If only
Slicers, Subtotals, Tables, Ranges, Sort criteria, OH MY. We've got it all in this post about dealing with frustration, solutions, and spreadsheet empowerment.