Reputation: 11
I have a large spreadsheet with multiple tabs. There is the main sheet that collects all the data entered through a form and then there are sub sheets with filtered information based on certain conditions like age for example. The sub sheets pull this data from the main sheet to which the form is linked using the FILTER() function. What I would like is for the google sheet to automatically add a new row with the filtered information each time a new entry is made. It does this for the main sheet where the form is linked, however for the filtered sub sheets you have to manually add new rows or the information will not populate. To be clear, I would like a new row added automatically containing the filtered information.
Upvotes: 1
Views: 2052
Reputation: 15328
If your formula is as follows
=filter('sheet with responses'!A:F;'sheet with responses'!C:C="criteria")
without specifying the rows, the new rows will be added in your filtered tabs.
Upvotes: 1