With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Tuesday, February 27, 2018
yogi_Auto Update Rearranged Data Received Via Form Responses
question by: Jasom Maki https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/RAJLVBJGq0k;context-place=forum/docs 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