| Issue with formulas when data is imported from google form to google spreadsheet. | Ben828 | 6/21/12 9:30 AM | I am using a google form to populate a google spreadsheet. Whenever a new form is filled out and data is imported into the spreadsheet all the formulas are deleted from that specific row. I can pull the formula down from the cell above it to get it |
| Re: Issue with formulas when data is imported from google form to google spreadsheet. | MarinusP | 6/23/12 2:49 PM | Hi Do not use: =A1+B1+C1 But =ARRAYFORMULA(A:A+B:B+C+C) In row 1 of an empty column. Please let me know if you have questions or suggestions. In that case, please share an example spreadsheet with anyone with the link, to edit. |