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.
Blog
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.
are you there, adrienne maree brown, it’s me, Sam
Shoutout to adrienne maree brown, and to all of you who sent me her spreadsheet post!
comparing lists in Salesforce Flow
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!
fieldnotes from testing a complex build
Lessons from UAT... and Taylor Swift gifs sprinkled throughout!
i’m learning Mastodon!
Some of observations and tips from my first few days trying Mastodon.
3 new-to-me spreadsheet capabilities (plus a bonus)
While analyzing survey data, I encountered 3 new spreadsheet capabilities in Excel and Google Sheets!
UnofficialSF: 8 Recipes for Custom Header Screen Flow Component
Wondering how to add some flair to your (Screen) Flows? I have just the recipes you need! Thanks to Sharad and the team at UnofficialSF for making Custom Header, the component that inspired this post!
the story of the slippers
On Dreamforce 2022, Lionheart Astro slippers, the Salesforce Golden Hoodie, and overcoming a bout of insecurity.