Remove Google Sheet Edit Alert

Des, very much appreciate your suggestions. I tried the array function as well as the import range. While it pulls the data in seamlessly, it stops working when I edit it.

Here is some of the data we’re pulling in from our Typeform: reason for visit. If a client comes and responds “fluffy needs a vaccines.” A receptionist will then check Fluffy’s record to see what vaccines are needed. She will then edit the “reason for visit” to read “fluffy needs rabies, kennel cough, and heartworm.” And upon making changes to a cell with information brought in via array or import range - it breaks :( 

All information goes away as the formula was broken :( 

that it will do @eepah .. i would suggest that you add a column to the ‘second tab’ next to the original where they are going to make changes - call one original and the the other updated. if there are any changes ie as in your image, they can be added to the updated cell without killing the formula. 

just a thought. 

For anyone jumping on this topic and in the same boat I am, you need to constantly be able to edit your incoming data and about to throw something if that Heads Up! pops up one more time: I found the solution! 

The entire sheet is under protection so the integration isn’t messed up. But if you know what you’re doing with your sheet and are sure you’re not going to mess it up, open up Date > Protected Sheets and Ranges and either delete the protection or just change it to the important columns/rows. 

Hope this helps!