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 <CODE4LIB@LISTS.CLIR.ORG> on behalf of Gregory Pierce <gpie...@arlingtonva.us> Sent: Wednesday, March 25, 2020 10:26:18 PM To: CODE4LIB@LISTS.CLIR.ORG <CODE4LIB@LISTS.CLIR.ORG> 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 > <suzanne.salisb...@mail.waldenu.edu> 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>
