Auto Populate second sheet
I have a main sheet with a form. As you know, every time a user submits a form, a new row appears. I was wondering if there is any way to have a separate sheet that connects to the main sheet so when a new entry is added through the form on the main sheet, a column is updated on the second sheet reflecting the new entry. It does not need to reflect the whole row (which would be fine if it did), but only a value in a column.
I hope this made sense!