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
> >
>