Help Integrating Google Sheets - " You're trying to edit part of this sheet that shouldn't be changed accidentally" | Community
Skip to main content
Answered

Help Integrating Google Sheets - " You're trying to edit part of this sheet that shouldn't be changed accidentally"

  • June 15, 2021
  • 1 reply
  • 1542 views

I’ve integrated the TypeForm into Google Sheets and while trying to edit the data, every few minutes I get a pop-up saying “Heads Up! You’re trying to edit part of this sheet that shouldn’t be changed accidentally. Edit anyway?” And I must close the pop-up to continue working. I am the owner of the Sheet and the other Editors are not receiving this message.

Does anyone know how I can make this go away? Thank you for your help!

Best answer by john.desborough

@Erin M - from another user here.

that first tab is the ‘dump’ page from Typeform.. I strongly recommend that you do not touch it .. even if it looks ugly and hard to read column headings

if you want to play with the data and make changes to headings, create another tab, call the columns something easier to read than the question from the typeform and then use the arrayformula() function to bring the data from the first tab into the second one every time there is a row added. 

this way you avoid the message you are getting and the (high) probability that you might mess up the integration between typeform and google sheets. 

just sayin’

 

des

View original

1 reply

john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5284 replies
  • Answer
  • June 15, 2021

@Erin M - from another user here.

that first tab is the ‘dump’ page from Typeform.. I strongly recommend that you do not touch it .. even if it looks ugly and hard to read column headings

if you want to play with the data and make changes to headings, create another tab, call the columns something easier to read than the question from the typeform and then use the arrayformula() function to bring the data from the first tab into the second one every time there is a row added. 

this way you avoid the message you are getting and the (high) probability that you might mess up the integration between typeform and google sheets. 

just sayin’

 

des


Reply