 |
 |
Hi Mackenzie, I haven't done this exact use case, but this is totally doable in a Google apps script (which is written in basic JavaScript within the code editor on your form), bit more on it here https://www.google.com/script/start/my In the script you have easy access to anything submitted in the form (and more broadly anything in gsuite that user has access to, including sending emails etc) and can use a conditional to open and write out data to a series of different spreadsheets on form submit based on whatever combination of form values you'd like. Best, Monica Monica Maceli, Ph.D. Associate Professor Pratt Institute | School of Information 144 W 14th St, 6th Floor, New York, NY, 10011-7301 www.monicamaceli.com | [log in to unmask] On Wed, Mar 25, 2020, 10:51 PM Mackenzie M. Salisbury < [log in to unmask]> wrote: > Hi all! > I am hoping someone out there has an excel formula or script that I can > use to solve this problem: > > I have a google form and I want the data from this form to go to different > sheets (different workbooks) based on an answer to one of the questions. > The trick is that the question may have more than one answer. The data > collected includes metadata as well as files. > > Alternatively, I would settle for an excel formula that would let me > import data of a whole row, based on a partial match of information from > one cell in a specific column. > > Anyone have any ideas? > > Best, > > Mackenzie Salisbury (she, her, hers)< > https://academicguides.waldenu.edu/diversity-inclusion> > Librarian, Digital Scholarship > Walden University Library< > https://academicguides.waldenu.edu/library?utm_source=outlook&utm_medium=email&utm_campaign=email_signature > > > <https://www.facebook.com/Walden-University-Library> > > <https://www.facebook.com/Walden-University-Library> > > <https://www.facebook.com/Walden-University-Library>[icon_facebook]< > https://www.facebook.com/Walden-University-Library> < > https://www.instagram.com/walden.university.library/> [icon_instagram] < > https://www.instagram.com/walden.university.library> < > https://twitter.com/WaldenULibrary> [icon_twitter] < > https://twitter.com/WaldenULibrary> < > https://academicguides.waldenu.edu/library/studentnews?utm_source=outlook&utm_medium=email&utm_campaign=email_signature> > [icon_libnews] < > https://academicguides.waldenu.edu/library/studentnews?utm_source=outlook&utm_medium=email&utm_campaign=email_signature > > >