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: google scripts

November 3, 2021January 20, 2022 Samantha Shain Uncategorized

how to populate multi-select picklists in Google Sheets and Salesforce

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!

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() importrange() import range() 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 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...