Do you need to edit multi-select picklist values in a Google Sheet and then import them into Salesforce? I have a script to help you transcend the limitations of data validation!
hay in a needlestack
What to do when you find data discrepancies?! I kinda felt like I did 6 loads of laundry, came out with socks I didn't even know I had, and then figured out how to match them up. Also, Spongebob, Rubix Cubes, and pivot tables.
call me, maybe?
Getting ready for your Q4 fundraising phone-a-thons? Follow these simple steps in Excel or Google Sheets to format your phone numbers for optimum ease!
normalize, normalize
Believe me, I have complete understanding for why you might not want to tackle that data junk drawer. That being said, I believe there are friendly, empowering, efficient ways to move through a data cleaning process. The first step is a mindset shift from thinking "we have already failed at this aahhhhhhh!" to "this is a normal, friendly, empowering way to take good care of our community!" Let's normalize data cleanup so we don't have to normalize data.
shape shifter
From a downloaded file with weird fonts and titles, wacky colors, no wrapped text, superwide columns, and repeating header rows, I was able to create a useable, sortable, shareable, printable, filterable, not-make-you-want-to-throw-your-computer-out-the-window spreadsheet. And you know what the best part is? You can too!
resource roundup + cool job alert
What do a camel, a mermaid, and an awesome job opportunity have in common? You'll have to read this post to find out, chock full of tips, gifs, puns and more!
Dear Spreadsheet Whisperer: Quickbooks, MS Access, and Spreadsheets, oh my!
In this installment of Dear Spreadsheet Whisperer, we hear from an old friend who's storing contact information in.... Quickbooks! I offer advice about how to make better use of contact segmentation features and how to begin to explore a better database system.
“Change management” for change-makers
What does the moon, popcorn, and caterpillars have in common? Changing phases, of course! This post is all about getting better at change management. BONUS: my favorite lil dumpster fire meme makes a cameo appearance!
do these data spark joy?
Inspired by Marie Kondo's new show about tidying your home, a post about keeping and deleting data in your spreadsheets and databases. With puns and gifs!
Do you learn from your mistakes?
What is a mistake? Let's use the etymology to learn some lessons about mistakes and spreadsheets. Plus, puns and a recommendation for learning more.