how to get array formulas to work in google sheets Kill this post if you would like but I thought it might be one to start with in the Community in terms of discussion: thought i would post here instead of directly to support to see if this is the type thing that could be discussed here in the community.. (the whole workflow process is geared to capturing the data into a google sheet, using Document Studio add-on to merge the data into a google doc template and then push a pdf out by mail to the respondent) I am trying to add a calculated column (or series of columns) into the Google sheet and have the field updated with each entry of a new row of data from Typeform BUT it is not working for me despite looking at about 2 hours of google support comments what seems to happen is that if i put in a calculated field using the ARRAYFORMULA method to add the calculated value automatically to the field in the new row, the google sheet does not accept any new Typeform results into the table. I have tried removing protec
