Hi! I would like to duplicate the ALL RESPONSES table onto new sheets, and generate two tables from that information. Basically, the form I have created will divide the respondents into two groups. So I would like to see a table that includes all responses (which is the default table), then another table with only group A, and another with group B. I figured it would be easier to just copy the main table and filter the info in the new ones. Is this possible? Is it possible also to build summary reports based on the newly created (filtered) tables? Thanks guys
You can add additional tables by going to the top Insert menu and selection "Sheet". You can then copy and paste data into it - note these other sheets/tables are not live data, nor are they connected to the original response table. They are just copies of the data.
The summary report currently can only show charts for the main response table, it won't work for the newly created sheets/tables.