We collect survey data via integration with Google Sheets. Question: Can we change column headers in a linked sheet while a survey is live?
Best answer by john.desborough
View originalWe collect survey data via integration with Google Sheets. Question: Can we change column headers in a linked sheet while a survey is live?
Best answer by john.desborough
View originali would not recommend it. If you are going to use the data for reporting and want more user friendly headings, add a tab to the Google Sheet and put your custom field names there as column headings and then use the arrayformul() function to pull the data across from the first tab into the second - this will ensure that with every new row added from the survey, the data is pulled into the second tab
do all your reporting off the second tab.
I do this on a number of typeforms for my business.
cheers
des
Thanks John, what does that arrayformula() look like, do you just put the first cell with data in the original tab in the brackets and drag over and down? Thanks
=arrayformula('Multiple Intelligence - How are you smart? - ww orig'!BF2:BF)
the name of the tab is pulled in by starting the formula in the cell and then doing the old click on the other tab and then the cell you want routine. The one thing you need to add is the entire range that this should be looking into ie in the example above it says bf2:bf which means start at cell bf2 and go down the entire range of cells
sometimes you will need to add a little more to the arrayformula if you are looking at doing calculations etc based on the column.. here’s another little bit
=arrayformula(if(isblank(A2:A), " ", (B2:B/35)))
note that this one checks to see of there is data in column A of the row being evaluated.. if there is not data leave the cell blank (“ “) otherwise put in the results of the calculation
hope that helps
thanks so much
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.