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

Tag: spreadsheet

October 1, 2024October 1, 2024 Samantha Shain Uncategorized

I merged two thousand duplicates in Salesforce manually, AMA

When faced with thousands of duplicates in Salesforce, what is the best way to merge them? Here's my reflection of merging them manually, and what I learned in the process.

Tags

=filter() accounting address() archives array automation Black Lives Matter change management civicrm 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 mastodon match() membership mentorship Metrics mindsets nationbuilder nonprofit 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 spreadsheet Spreadsheets sprints statistics SUBSTITUTE() sumif() systems testing thought piece training TRIM() Tutorial unique() unofficial sf user adoption video games vlookup() xappex xlookup() You Can Do It! Zapier
Powered by WordPress.com.
 

Loading Comments...