CODEWITHSUNDEEP
google-sheetsgoogle-forms
bilbo sareen
bilbo sareen

Reputation: 31

Auto Populating From Sheets Into another Sheet

I have one google spreadsheet that syncs responses from two google forms. There are three sheets in this spreadsheet: form responses 1, form responses 2 and data. I want to sync the data from form responses 1 to to the relevant columns in data as soon as new responses appear in it. Is there a way to do this?

enter image description here

enter image description here

To illustrate, what I want to do here is take any new data from the "date" "activity" and "notes" and append it to the same name columns in the "raw data" sheet.

Upvotes: 0

Views: 158

Answers (1)

player0
player0

Reputation: 1

try in Raw Data sheet in the Date column:

=FILTER('Form Responses 2'!B2:B; 'Form Responses 2'!B2:B<>"")

Upvotes: 1

Related Questions