Tuesday, February 27, 2018

yogi_Auto Update Rearranged Data Received Via Form Responses

Google Spreadsheet   Post  #2385

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-27-2018

question by: Jasom Maki
Reference cell from form response tab in another sheet
I know there must be a solution to this challenge I am having. I have read quite a few forum threads that get close to solving my issue but I have not found a solution that really works. I know others are having the same issue as me. I am hoping someone can help.

I work in a department that collects event details from other departments so that I can advertise them through various channels. I want to build in some efficiencies to the current process. I created a Google Form where others can submit event details. I would like to populate the repsonses into predefined columns I have in another sheet.

Unfortunately I can not simply reference a cell from the responses sheet because as new responses come in it adds a new row to the responses sheet and does not send that data to the sheet where I want it to be referenced.

In my research I have seen the indirect function which seems to work however i cannot drag the formula across multiple cells. I am not very savvy with formulas. I am happy to provide more detail, please ask. I  think this thread could be very helpful for others if we are able to find a solution. Thank you

my sheet is:

and my form is: