I’m new to using Google Sheets with Asana, and would like to set up a system whereby whenever a tag e.g. “designers” is added to a task, that populates a row in my Designers table in my Google Sheet with: assignee, project name, task start date, task finish date?
I tried to find information on what you proposed. I’m not seeing it, or I’m misunderstanding your solution.
Is there a way to tie google sheets to a project, so each new task gets a row in google sheets? I only seem to be able to find using the dashboard and seeing things on the project basis.
Sadly I don’t have that kind of technical knowledge (as you can probably tell). When you say multihome a task - you mean it would be in its normal project but also replicated in a fresh project called “Designers”? How do you do that?
Also the google sheet I’d want would have only those fields in assignee, project name, task start date, task finish date - not the extra stuff that seems to come in as standard.
I’m sure we’re close to a solution, so appreciate your help.
I’d be grateful for your help. I have done as you said and created a “designers” project populated with tasks that have the tags “desginer”, and exported that to a Googlesheet. I can see in the “Task Count” section the number of tasks and the number of incomplete. In the last section “incomplete tasks by assignee” I just see the number, what commands/formulas do I need to run to see:
Your other idea is interesting. I’ve created an advanced search report for all tasks with a certain tag. How do I then get that data into a google sheet with live data? I can export to CSV but then it won’t update when deadlines change etc.
Let me know if you have any ideas - thanks for all your help.
In regards to Google Sheets, by default, you will get all fields available; if you only want the “assignee, project name, task start date, task finish date”, you would need to edit the sheet manually I’m afraid!
Thanks. I did actually manage to multihome those tasks, and then export that project to googlesheets from my dahsboard. However, that standard google sheet does not seem to contain the data I need: assignee, project name, task start date, task finish date?
The only info about the assignee it seemed to contain was the number of tasks complete/in complete.
If the data I need is in there somewhere, please tell me how to access it.
@leila, I found another workaround. You could also do an advanced search (on the specific things you want), save that search and then select ‘sync to Google’ (if you have that option available).
This would then generate a ‘live’ view of that particular search-result. The delay is about one hour (according to Asana). You cannot edit the contents of the cells (the formatting is possible> turning numbers into actual dates) within Google sheets, since it is an IMPORTDATA function only in the first cell, but you can hide the columns you don’t want to see).