Google Spreadsheet Post #2385
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Feb-27-2018
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
my sheet is:
https://docs.google.com/
and my form is:
No comments:
Post a Comment