I developed a Google Form that copies responses to a linked output spreadsheet in Google Sheets.
In addition to the columns created by the form question/responses themselves, I've added additional custom columns. These columns contain functions (and formatting) to manipulate and utilize the response data for a script I wrote. I copied the generic functions through each row for these additional columns.
Everything works as I expect, except....
Every time another user fills out the form (i.e., every new response I receive), a new row is created in my Google spreadsheet instead of simply "adding" to my next function-containing row. As a result, the new response rows are added without the generic functions/formatting, leaving my previously "set up" rows below the newly added response row.
Is there some way to have new response rows be created in a way that incorporates functions in the non-form column cells?
- In other words, I don't want to have to copy functions into cells of new rows every time a new response is generated, but instead to have these functions "auto-fill."