I have two separate marketing lists on spreadsheets, both of which were originally opt-in, but have been residing on different systems - System A for email marketing and System B for SMS marketing. List A has the users' email addresses, cellphone numbers and names. List B just has the users' cellphone numbers (plus a column called "unsubscribed" for those people who. I want to combine the two spreadsheets to create one spreadsheet while keeping the column called "unsubscribed" so I know which people to keep permanently removed. Can you advise me on how to synchronise these two spreadsheets using the cellphone number as the common data? Thanks!
posted by skylar
on Jun 3, 2013 -
I like to write using google docs. I used to have a functioning bookmark that was a one-step to new doc solution, which I loved, because it was simple, and efficient. Some time ago that bookmark stopped working, and now it's a matter of several mouse clicks. This is a very small matter, but if someone has a one step solution they care to share, well, that would be delightful.
posted by letstrythis
on Sep 14, 2012 -
How can I programaticaly copy ranges from google docs spreadsheet to a fusion table? [more inside]
posted by Popcorn
on Aug 17, 2011 -
Spreadsheet question: I want a column containing all the names in THAT column EXCEPT all the names in THOSE columns. [more inside]
posted by Salvor Hardin
on Aug 2, 2011 -
Google docs has denied us access to a document, saying "it is in violation of our Terms of Service." We need that document! What can we do? [more inside]
posted by ManInSuit
on Aug 30, 2010 -
Hi, I searched through the archives and did not find a match. Thank you in advance.
Let's say I have a spreadsheet in Google docs with two columns, names and dollar amounts. Jane Smith, $5; Joe Sixpack, $7; Jane Goodall, $4; Joe Frankin, $10, etc.
I want to use – I think – the QUERY function to ADD up all the dollars that all the Joe's have, or all the dollars that the Jane's have.
I have read through as much documentation as I can find and it's not giving me enough to formulate a successful query.
=query(A1:B20, "Select A where (A contains 'jane')", sum(B))
does not work.
posted by noway
on Mar 22, 2010 -
Looking for a way to have Google forms/spreadsheet send an e-mail notification when a form has been filled out. [more inside]
posted by jmd82
on Oct 23, 2009 -
Is a published Google Doc document autoindexed by Google or hidden until it is first linked by another page? [more inside]
posted by nolnar
on Aug 28, 2009 -
I have an xls file I got from a survey I created on Google docs. Now I want to make it pretty without copy-pasting every bloody cell
into an Indesign document… [more inside]
posted by monocultured
on May 17, 2009 -
Trying to find the best option to make a Google map using data entered into a Google docs spreadsheet. I'd prefer not to have to learn much about coding to do this, but would like the map to update with changes to the spreadsheet, including assorted details... [more inside]
posted by Unsomnambulist
on Sep 13, 2008 -