Here is a copy of the form I’m using: https://forms.gle/B7yqSpNfr8W8PjGm8

We are trying to organize information by Department by having separate sheets based on this...if possible.

If it isn’t — we will just copy and paste by hand but I’m hoping there is a semi automated way?

Thanks!
Mackenzie

Mackenzie Salisbury (she, her, hers)
Librarian, Digital Repository
Walden University Library
________________________________
From: Code for Libraries <[log in to unmask]> on behalf of Gregory Pierce <[log in to unmask]>
Sent: Wednesday, March 25, 2020 10:26:18 PM
To: [log in to unmask] <[log in to unmask]>
Subject: Re: [CODE4LIB] Google Forms/Spreadsheets/Folders

EXTERNAL EMAIL: Do not click on any link or open any attachment unless you trust the sender and know the content is safe.


Could we see an example of the data you’d possibly be pulling?

> On Mar 25, 2020, at 10:51 PM, Mackenzie M. Salisbury <[log in to unmask]> wrote:
>
> EXTERNAL EMAIL
>
>
> 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://secure-web.cisco.com/1LW8PZKbzvEq5bNp6BotqPk4HWSLHCQbX4qULTN5PD4nadCuUtPRK_U-gza0rGvrsau0YPBzLTN3XZATPWZ61cQNJA5ActaD-c9uJgGQHReAe3N1Lre-PPRRoqpg6oA8Te8KyfnQyeKVo4q3xtGV8hrlKatkouH3ay9aP5lQzieZQEJCkxYLdADrpV_abyAYX502sMpBPjWbCrq5htbCU7HxVMRCBFlW73ks7i_DITC9cRjXXaleXIeyMXFQHhfHl57J9UaaZjDJycQXvRHTJovjzaR_newSsyFSm3JXRMA7KjBii6vJ-SFFXS2W3SfIt-UTUxHUwlRWsRD6_s7eFUQ/https%3A%2F%2Fnam03.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Facademicguides.waldenu.edu%252Fdiversity-inclusion%26data%3D02%257C01%257Cgpierce%2540ARLINGTONVA.US%257Cf31f692a5b50420cc9c908d7d1308f58%257C803548041fdf428e9f5f5091e994cf54%257C0%257C0%257C637207878899378756%26sdata%3DRnlHPoGg8dI%252Bej6P3a8Gpnv%252FsWd4Gm8S1Qco93%252Bltqo%253D%26reserved%3D0>
> Librarian, Digital Scholarship
> Walden University Library<https://secure-web.cisco.com/1S2AdZtxnycVzBZ1outwvsBWcaZYGMdMFK-xuuPgeo_AHYDE-BcDZfkWWmuFy6JfmisxC4cElUDOok77oQt8TnP8JFlnhKxYhfMkbOgn3UywzdulB-vFPTliWDzIE8fjRMvIXeqHaav-fW3zH2ozfR0LuiGk5WgPZM1YhJvUypLZYzBiOxG-IxvF7Cpvm84K31xDXn_OB7V5XTINp_nYhxCQk6o3AQ3Lbb4EZZXhVXugq_k3L4vGsuHeQuF85-cgH6iGOz8A0Q_UAT8At6L7YpmGxZLDTy04U8jWg-DlkPzwGA3t8g2_1wJclz6TGECb9xkee_ocGVSVBN-SuH9C5NQ/https%3A%2F%2Fnam03.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Facademicguides.waldenu.edu%252Flibrary%253Futm_source%253Doutlook%2526utm_medium%253Demail%2526utm_campaign%253Demail_signature%26data%3D02%257C01%257Cgpierce%2540ARLINGTONVA.US%257Cf31f692a5b50420cc9c908d7d1308f58%257C803548041fdf428e9f5f5091e994cf54%257C0%257C0%257C637207878899378756%26sdata%3Dc4KkBBLRaXGRmkMfoClUFuSey3l1MCpXgmiOtoo%252F32o%253D%26reserved%3D0>
> <https://secure-web.cisco.com/1envMPecLqIGqAbaPngEFzBEvrgdGF4kgOJ59E-rHFwJ1e5ekF1FtNVp8t5YL5x0CWIQYc1mTx4X6lkMwirRiWIeuvg6xB5rempsds-vF2QvW76yRTXFHKPTBwid3G-x_QTcRyu72KnmBOlBviLrt3LDcfeu886_JNHaa2LaFfSUV8TxxyX4RRjGWqsbk-Iiv44lFZF52b6gLHRrLHL5uQZ01lkCSjoFZX3BnWWsQJza3gNtb7IWjz6H7TeMZ1IH1vG8N-_1sz1yeWs05ignoxRCv8kbZi4NWxO9VoDjgtfuCBTKfTowt4qIsDzxX5SrrzwhBf7rxickSDrq30Wmhyw/https%3A%2F%2Fnam03.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.facebook.com%252FWalden-University-Library%26data%3D02%257C01%257Cgpierce%2540ARLINGTONVA.US%257Cf31f692a5b50420cc9c908d7d1308f58%257C803548041fdf428e9f5f5091e994cf54%257C0%257C0%257C637207878899378756%26sdata%3DrUBY%252BXG8xBi1CXwf1mtWoIsnWEDoKBCepg4Ba5v5scg%253D%26reserved%3D0>
>
> <https://secure-web.cisco.com/1envMPecLqIGqAbaPngEFzBEvrgdGF4kgOJ59E-rHFwJ1e5ekF1FtNVp8t5YL5x0CWIQYc1mTx4X6lkMwirRiWIeuvg6xB5rempsds-vF2QvW76yRTXFHKPTBwid3G-x_QTcRyu72KnmBOlBviLrt3LDcfeu886_JNHaa2LaFfSUV8TxxyX4RRjGWqsbk-Iiv44lFZF52b6gLHRrLHL5uQZ01lkCSjoFZX3BnWWsQJza3gNtb7IWjz6H7TeMZ1IH1vG8N-_1sz1yeWs05ignoxRCv8kbZi4NWxO9VoDjgtfuCBTKfTowt4qIsDzxX5SrrzwhBf7rxickSDrq30Wmhyw/https%3A%2F%2Fnam03.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.facebook.com%252FWalden-University-Library%26data%3D02%257C01%257Cgpierce%2540ARLINGTONVA.US%257Cf31f692a5b50420cc9c908d7d1308f58%257C803548041fdf428e9f5f5091e994cf54%257C0%257C0%257C637207878899378756%26sdata%3DrUBY%252BXG8xBi1CXwf1mtWoIsnWEDoKBCepg4Ba5v5scg%253D%26reserved%3D0>
>
> <https://secure-web.cisco.com/1envMPecLqIGqAbaPngEFzBEvrgdGF4kgOJ59E-rHFwJ1e5ekF1FtNVp8t5YL5x0CWIQYc1mTx4X6lkMwirRiWIeuvg6xB5rempsds-vF2QvW76yRTXFHKPTBwid3G-x_QTcRyu72KnmBOlBviLrt3LDcfeu886_JNHaa2LaFfSUV8TxxyX4RRjGWqsbk-Iiv44lFZF52b6gLHRrLHL5uQZ01lkCSjoFZX3BnWWsQJza3gNtb7IWjz6H7TeMZ1IH1vG8N-_1sz1yeWs05ignoxRCv8kbZi4NWxO9VoDjgtfuCBTKfTowt4qIsDzxX5SrrzwhBf7rxickSDrq30Wmhyw/https%3A%2F%2Fnam03.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.facebook.com%252FWalden-University-Library%26data%3D02%257C01%257Cgpierce%2540ARLINGTONVA.US%257Cf31f692a5b50420cc9c908d7d1308f58%257C803548041fdf428e9f5f5091e994cf54%257C0%257C0%257C637207878899378756%26sdata%3DrUBY%252BXG8xBi1CXwf1mtWoIsnWEDoKBCepg4Ba5v5scg%253D%26reserved%3D0>[icon_facebook]<https://secure-web.cisco.com/1envMPecLqIGqAbaPngEFzBEvrgdGF4kgOJ59E-rHFwJ1e5ekF1FtNVp8t5YL5x0CWIQYc1mTx4X6lkMwirRiWIeuvg6xB5rempsds-vF2QvW76yRTXFHKPTBwid3G-x_QTcRyu72KnmBOlBviLrt3LDcfeu886_JNHaa2LaFfSUV8TxxyX4RRjGWqsbk-Iiv44lFZF52b6gLHRrLHL5uQZ01lkCSjoFZX3BnWWsQJza3gNtb7IWjz6H7TeMZ1IH1vG8N-_1sz1yeWs05ignoxRCv8kbZi4NWxO9VoDjgtfuCBTKfTowt4qIsDzxX5SrrzwhBf7rxickSDrq30Wmhyw/https%3A%2F%2Fnam03.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.facebook.com%252FWalden-University-Library%26data%3D02%257C01%257Cgpierce%2540ARLINGTONVA.US%257Cf31f692a5b50420cc9c908d7d1308f58%257C803548041fdf428e9f5f5091e994cf54%257C0%257C0%257C637207878899378756%26sdata%3DrUBY%252BXG8xBi1CXwf1mtWoIsnWEDoKBCepg4Ba5v5scg%253D%26reserved%3D0>  <https://secure-web.cisco.com/1qPZA-ps4ppLs_KH3X-zh-L-L8WsOi_j5X0aJAlcudx7nrPH2YkMFZ6DthzO54g93d7KO_GrGLaZWOvD8WxCNk7LFdTK8EN0URu7gQL7ZHAMj5USWgjZKu9f5jfSx-2OupDk7DIKKfcR6UcWJXt90wCnTsjBEhThrut2etgHUBcLvdYg3C9OWN4lQRO2hPWeI9JxzR3YKTL7LSq5co7I7WBpJSmqKlN-CfFFEDBZN-c0u0vcuU2L333xjwiiGqrgELJbL_1plxV9AXCZ-BoZ4W-ajuW-Ye9o6dbI879dc-6R1MgCW7YoHpZrGpGSl7IsAFtGug3P57nUO9cNKquvSvQ/https%3A%2F%2Fnam03.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.instagram.com%252Fwalden.university.library%252F%26data%3D02%257C01%257Cgpierce%2540ARLINGTONVA.US%257Cf31f692a5b50420cc9c908d7d1308f58%257C803548041fdf428e9f5f5091e994cf54%257C0%257C0%257C637207878899378756%26sdata%3D2pNQNcXeAJxIlnzlOuG1FFC5Lj4GfomXZJp0TelIi04%253D%26reserved%3D0> [icon_instagram] <https://secure-web.cisco.com/1Jl8M8iGSOu6cuUiiv4Q3rYVxBFxOHS_qm3UYH72ooO22P-t9mp6jueaFo7J8P7TxkgN7TnkdvdLszsDc3ic4g3CQkRYab12_6wkbBTvGuFpRqEx9A9WK0qK8Qc4Jn2AtVSUhx4cp2uAgphqDVnfYKMk7wib64ft0K9P9i0Ik7J1e4oHU4VVtz8enHwRVnDPfRwxTmSc7NxHQkociXdLY-zUF6ak_WBF9lxIolOElpH00WjaCij2pFI1RpNJNOu2W6gBQGn-tQ3_HXicGsDNmYnKSBNW-4Jk3atDb2bfc-wYWZRWHJWsmr6GhpO__8DNYNaD5E8hqdz6qTSFYNeBEWw/https%3A%2F%2Fnam03.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.instagram.com%252Fwalden.university.library%26data%3D02%257C01%257Cgpierce%2540ARLINGTONVA.US%257Cf31f692a5b50420cc9c908d7d1308f58%257C803548041fdf428e9f5f5091e994cf54%257C0%257C0%257C637207878899378756%26sdata%3DeKTGbatSPtw0A9HRscmcnqaTayyoYtVlOT4XmlvgtA4%253D%26reserved%3D0>   <https://secure-web.cisco.com/1MmmhMduiqHEVzMMWd-KNWUQdKbNHCIVEAk021nJonUbCHY6mqKjllM6S7BQD7d83prka8063n6Si4MeXhxgm-7sOvgBft1sYJVt6R0dU086Ftzhqxza3TnjBvookCE5Z98lYe0_0QPpAMg-8sDZ3k9louQ2QvQatqsGq0SoRBtvnFGTv3P85K299Pf9jAcsC7HeqCUVmFLwKjsszy0oOXhY6EfnSi3q-a3zNMbecjvDUYr-BZ0M81WJ_iFieQHFV06YTeZPlBSk2qk_bvHWmLTzSNel-7RHs9JHSDwrnvp8rTWvbrtblEcEkzFGwH4BscEqr-UkxMqaJe6PpM3w6-g/https%3A%2F%2Fnam03.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Ftwitter.com%252FWaldenULibrary%26data%3D02%257C01%257Cgpierce%2540ARLINGTONVA.US%257Cf31f692a5b50420cc9c908d7d1308f58%257C803548041fdf428e9f5f5091e994cf54%257C0%257C0%257C637207878899378756%26sdata%3DXKQc8%252FGsS7eH2SlbZQk65ofLgj%252Bzh%252FD3WGFrsDAorEE%253D%26reserved%3D0> [icon_twitter] <https://secure-web.cisco.com/1MmmhMduiqHEVzMMWd-KNWUQdKbNHCIVEAk021nJonUbCHY6mqKjllM6S7BQD7d83prka8063n6Si4MeXhxgm-7sOvgBft1sYJVt6R0dU086Ftzhqxza3TnjBvookCE5Z98lYe0_0QPpAMg-8sDZ3k9louQ2QvQatqsGq0SoRBtvnFGTv3P85K299Pf9jAcsC7HeqCUVmFLwKjsszy0oOXhY6EfnSi3q-a3zNMbecjvDUYr-BZ0M81WJ_iFieQHFV06YTeZPlBSk2qk_bvHWmLTzSNel-7RHs9JHSDwrnvp8rTWvbrtblEcEkzFGwH4BscEqr-UkxMqaJe6PpM3w6-g/https%3A%2F%2Fnam03.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Ftwitter.com%252FWaldenULibrary%26data%3D02%257C01%257Cgpierce%2540ARLINGTONVA.US%257Cf31f692a5b50420cc9c908d7d1308f58%257C803548041fdf428e9f5f5091e994cf54%257C0%257C0%257C637207878899378756%26sdata%3DXKQc8%252FGsS7eH2SlbZQk65ofLgj%252Bzh%252FD3WGFrsDAorEE%253D%26reserved%3D0>   <https://secure-web.cisco.com/1aG7VWGiFcAq6w169sXgQXIKM2I51hzL6H8fVrvGKccXoK5kPnsNREGWJPDes_wBDQe20tcWsvvHDo5LT2xFHA4hfnaB0mlV0AZzU9tzpdH26jW6ZBefE6ocZXm7ZR24sum-JrcrNyDhePnScKrs_5sKKlTwn0-U4f1JY7hMQMNGFFbNXrpintHdvkhFJGEZ51Ts97zTjFp48mKP_MesKx8Rs-ndiDMBvTLHoFftXlsEhPeGniTybyEBFHsVpdOzUskqWpKTzuJC9HjU7lNqBU6DVcuExq5xd8ZDfvx0VUmpwXSwIoZSkr1dU8nQ88AXeAArF_wMQZmp_pRQfj1vSEw/https%3A%2F%2Fnam03.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Facademicguides.waldenu.edu%252Flibrary%252Fstudentnews%253Futm_source%253Doutlook%2526utm_medium%253Demail%2526utm_campaign%253Demail_signature%26data%3D02%257C01%257Cgpierce%2540ARLINGTONVA.US%257Cf31f692a5b50420cc9c908d7d1308f58%257C803548041fdf428e9f5f5091e994cf54%257C0%257C0%257C637207878899378756%26sdata%3Dhn%252F00LkpqKpknccg83PbW5crto8OTsJizo51KBtz7%252BI%253D%26reserved%3D0> [icon_libnews] <https://secure-web.cisco.com/1aG7VWGiFcAq6w169sXgQXIKM2I51hzL6H8fVrvGKccXoK5kPnsNREGWJPDes_wBDQe20tcWsvvHDo5LT2xFHA4hfnaB0mlV0AZzU9tzpdH26jW6ZBefE6ocZXm7ZR24sum-JrcrNyDhePnScKrs_5sKKlTwn0-U4f1JY7hMQMNGFFbNXrpintHdvkhFJGEZ51Ts97zTjFp48mKP_MesKx8Rs-ndiDMBvTLHoFftXlsEhPeGniTybyEBFHsVpdOzUskqWpKTzuJC9HjU7lNqBU6DVcuExq5xd8ZDfvx0VUmpwXSwIoZSkr1dU8nQ88AXeAArF_wMQZmp_pRQfj1vSEw/https%3A%2F%2Fnam03.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Facademicguides.waldenu.edu%252Flibrary%252Fstudentnews%253Futm_source%253Doutlook%2526utm_medium%253Demail%2526utm_campaign%253Demail_signature%26data%3D02%257C01%257Cgpierce%2540ARLINGTONVA.US%257Cf31f692a5b50420cc9c908d7d1308f58%257C803548041fdf428e9f5f5091e994cf54%257C0%257C0%257C637207878899378756%26sdata%3Dhn%252F00LkpqKpknccg83PbW5crto8OTsJizo51KBtz7%252BI%253D%26reserved%3D0>