Filter & sort responses
Filter a form's responses by date, status, score or answer from the column headings of the Responses table, sort them by date or score, and see how the same filter drives Summary and the CSV export.
You narrow the Responses table the way you narrow a spreadsheet: from the column headings. The same filter also drives Summary and Download CSV, so the three always describe the same responses.
Which columns filter
A column that filters shows a small funnel after its heading. Click anywhere on the heading to open its menu.
The first column (Response or Submitted)
Sort: Newest first or Oldest first. Date: Today, Last 7 days, Last 30 days or Custom range, with a From and a To date.
Status
Completed and Partial, each with how many responses have it.
Score
Sort: Highest first or Lowest first. Score range: a Min and a Max. Only on forms that score.
Every Single choice, Multiple choice and Dropdown question
One checkbox per option, with how many responses picked it. A Search options box appears when there are more than eight options.
Text, contact, website, slider, file upload and scheduler columns have no filter. To look through text answers, search them one question at a time in Summary.
Step 1: Click a heading to open its menu. Here, Status.
On a phone, the menu opens as a sheet from the bottom of the screen. Every menu has a Clear button at the bottom, which removes that column's filter and its sort.
Step 2: Check the options you want. On a choice question, the counts next to each option cover every response, before any filter, so you can see at a glance how big each group is.
How filters combine:
Inside one question, any checked option matches. A multiple choice answer matches when any of its picks is checked.
Across columns, a response has to match every filter you set.
Checking both Completed and Partial is the same as no status filter.
Step 3: Read the filter bar above the table.
Each filtered column gets a chip, for example Status: Partial. The x on a chip removes that filter.
A sort other than Newest first gets a chip too.
The count tells you how many responses are left, for example 11 of 27 responses.
Clear all removes every filter and puts the sort back to Newest first.
The funnel of a filtered column turns into a filled badge with the number of active filters, plus an arrow when that column sorts the table.
Dates
Days are read in your Workspace timezone. See Workspaces.
Today is today in that timezone. Last 7 days is today and the six days before it; Last 30 days is today and the 29 before it. A shared link with one of these keeps counting back from the day it is opened.
Custom range takes whole days. You can leave From or To empty to leave that side open.
The date filter and the date sort use the moment a response was first saved. A response captured at the partial point on Monday and completed on Wednesday counts as Monday.
Score
Min and Max are inclusive. Fill in one of them to set only a floor or only a ceiling.
The filter applies when you stop typing for a moment, or when you press Enter.
A score is a whole number, so a decimal bound is rounded inward: a Min of 5.5 keeps scores of 6 and up.
Highest first and Lowest first sort by score; responses with the same score stay newest first.
Picking the sort that is already on puts the table back to Newest first.
Filters live in the address bar
Everything you set is written into the page's address, so you can bookmark a filtered view or send it to a teammate. The filter follows you between Summary and Responses. Changing a filter takes you back to the first page and closes the response panel.
A link from before the heading filters, with ?status=completed or ?status=partial, still opens with that Status filter on.
When nothing matches
The table keeps its headings, so you can undo what you did, and reads No responses match these filters / Remove a filter, or clear them all, to see more. with a Clear all button.
What follows the filter
Responses
Shows only the matching rows, in the order you picked.
Counts only the matching responses and shows the same chips. It has no sort.
Download CSV
Downloads every matching response, in the order you picked, whatever page you are on. See Export to CSV.
Export CSV (selection bar)
Ignores the filter and the sort: it downloads exactly the rows you checked.
What's next
Submissions: the table, the response panel and full screen.
Summary: the filtered answers, question by question.
Export to CSV: take the filtered responses into a spreadsheet.
Last updated