Hi, I have an Asana form that we are using for staff award nominations. We are getting hundreds of responses, and of course, they are showing as individual tasks in the Asana dashboard. Is there a way we can collate all the responses into a spreadsheet automatically so we can sort responses more easily than manually entering them into a spreadsheet?
Hi Stephanie, thanks for your response, but perhaps I didn’t explain myself properly. There is an Asana form that people complete which has various fields within it. Now the tasks are all called the same thing ‘Staff awards nomination form submission’ so not sortable. What I’m asking is whether there is a way for all the content within each field to be displayed in rows and columns as a spreadsheet. If the form fields are:
Name of nominator:
Award nominated for:
Name of Nominee:
And each person responds, I would like to see a spreadsheet with all the responses to all the forms.
It seems like you may not be connecting form questions to custom fields, which is easy to do ahead of time but not after the fact. If you do that, that will create the “columns” you would see in a spreadsheet.
Regarding each task having the same task title, that’s a setting in the forms editor (right-most tab).
It’s all documented here:
You can export a project to a CSV if you want: Project actions menu > Export > CSV.