I have read through a lot of responses and tried many of the "fixes"
Such a good tool but you really rely on it and when it doesn't work, it is devastating. I have used it many times.
Backgrouhd Information
Column on spreadsheet autopopulates with approved data. Form should pick up data and when user sees the information can pick the appropriate data for their needs.
--Is it the autopopulate formula on google sheets that is bothering it? How can I set this up so it auto populates on my sheet (Without filling in a form)?
Here's what I have tried?
On the form
- reset the form ranger
- turned off populate, waited three seconds, and turned it back on
- added the word refressing, then updated the questions
- Deleted old question and added NEW question
All of these have rendered no data (whereas when I originally set it up it took some of the data)
On the sheet
- I have updated the formula to be less long?