Get instant live expert help on I need help with google form to spreadsheet
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
2 questions: 1. We have created a google form and the data populates into the following google sheet "Form Responses 1" tab. When google form populates the spreadsheet the macros disappear for columns P & Q. Do you know why this happens? 2. I need a formula: If E & F on "Form Responses 1" matches C & D on "Form 2", copy & paste A & B on "Form 2" to P & Q on "Form Responses 1"
Solved by T. S. in 17 mins
I have a google sheet that is the response table to a google form. On the spreadsheet there is a multiple IF formula based around the value of TODAY(). It has stopped working and I cannot find why.
Solved by F. A. in 30 mins
*Note: please do not move columns around as I have a google form setup to populate this spreadsheet. There are 3 tabs, "Form Responses", "Form 2", "PRINTForm"; On "PRINTForm", when I add a Record No. on the top right corner, it should populate the form with the info from that Record No. row in "Form Responses" I will refer to these tabs as FR = "Form Responses", F2 = "Form 2", PF = "PRINTForm"
Solved by K. E. in 30 mins
Need help fixing formulas to track input data from a Google Form.
Solved by A. U. in 13 mins
i use google sheet to save data from google form. for example, production have send their problem of machine from their assembly by google form. then, technician will receive from google sheet and do their works.my question is how to update the status of machine automatically when technician have done to do their works
Solved by V. L. in 12 mins