Skip to content

The Data are Alright

  • Home
  • Blog
    • Spreadsheets
    • Civil Writes
    • Salesforce
    • Conga Composer
  • Dear Spreadsheet Whisperer
  • Consulting services
  • About
    • Testimonials
    • Link tree
    • Contact me

Category: Uncategorized

September 8, 2023September 8, 2023 Samantha Shain Uncategorized

How to calculate *conditional* Average, Median, and Mode in Google Sheets

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.

August 31, 2023August 31, 2023 Samantha Shain Salesforce, Uncategorized

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!

July 18, 2023July 18, 2023 Samantha Shain Dear Spreadsheet Whisperer, Uncategorized

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!

May 26, 2023May 26, 2023 Samantha Shain Conga Composer, Salesforce, Uncategorized

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).

April 12, 2023 Samantha Shain Salesforce, Uncategorized

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!

March 29, 2023March 29, 2023 Samantha Shain Dear Spreadsheet Whisperer, Uncategorized

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.

March 5, 2023March 5, 2023 Samantha Shain Uncategorized

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.

December 19, 2022December 19, 2022 Samantha Shain Spreadsheets, Uncategorized

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!

December 8, 2022December 8, 2022 Samantha Shain Uncategorized

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!

December 5, 2022December 5, 2022 Samantha Shain Salesforce, Uncategorized

fieldnotes from testing a complex build

Lessons from UAT... and Taylor Swift gifs sprinkled throughout!

Posts navigation

Older posts

Tags

=filter() accounting address() array automation Black Lives Matter change management civil rights movement Civil Writes code conditional formatting conferences Conga Composer consulting counta() countif() crafting CRM cumulusci Data database data cleaning data culture data validation Data visualization de-dupe Dear Spreadsheet Whisperer EQAT error messages Excel facilitation feedback feminism filter() form assembly forms Formulas fundraising Google Drive google scripts Google Sheets grantmaking if() ifna() import range() importrange() Impostor Syndrome indirect() integration interviews Justice large() LEFT() LEN() life with goldie listicle loops Mailchimp mailing list Mail Merge master's tools match() membership mentorship Metrics mindsets nationbuilder npsp openrefine open source phonebanking Pivot Tables poem PROPER() Public Health puns queer query() racial equity recruitment relational database reporting reproductive justice REPT() resource roundup RIGHT() rows() Salesforce salesforce flow search() self care SEO Single Source of Truth snowfakery social justice Spreadsheets sprints statistics SUBSTITUTE() sumif() systems testing thought piece TRIM() Tutorial unique() unofficial sf vlookup() xappex xlookup() You Can Do It! Zapier
Powered by WordPress.com.
 

Loading Comments...