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: address()

May 17, 2022May 17, 2022 Samantha Shain Spreadsheets

How to interpret survey data in Google Sheets with dynamic charts and drop down menus

Sorting through Google Form survey responses? What if I told you that you didn't have to rely on the auto charts from Google Forms, and instead, you could develop a fully automated, responsive, Google sheets dashboard for disaggregating data and drawing insights from the data? Here's how!

Tags

address() array automation Black Lives Matter change management civil rights movement Civil Writes code 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() forms Formulas fundraising google scripts Google Sheets if() ifna() importrange() Impostor Syndrome indirect() interviews Justice LEFT() LEN() 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 racial equity recruitment relational database reporting reproductive justice REPT() resource roundup RIGHT() rows() Salesforce salesforce flow self care SEO Single Source of Truth snowfakery social justice Spreadsheets sprints statistics SUBSTITUTE() sumif() systems thought piece TRIM() Tutorial unique() vlookup() xlookup() You Can Do It!
Powered by WordPress.com.
 

Loading Comments...