Hi, I´ve sucessfully set up the sync to Google Sheets and reference the data in a secondary tab with only the columns I need for the overview.
All good on that front. But is there any way of having only Tasks show and exclude subtasks. The overview becomes messy with all the subtasks showing.
Use case: Creating an overview for people in our org that are not using Asana.
Limitations: Due to security setting from parent company, the “Public link” functionality has been disabled.
Hi Larry, Thank you for the suggestion!
Yes please, I didn´t realise I had put it in the private section.
When looking in the parent column in Asana the subtasks aren´t in that column. They are nested under each taks as normal.
When checking the Google sheet, the subtask are pulled into the same column.
There are columns that are not filled in in Asana in my board when it´s a subtask, wonder if I could have Sheets remove those line (Subtask lines) when those columns are blank
Doesn’t Parent task have the title of a subtask’s parent when the row is a subtask? That’s how I thought it worked, meaning that if Parent task has any value, you’d want GSheets to filter it out so you are left only with top-level tasks.
Thanks Larry.
The subtask come in under their own name. Meaning that they do not have any name reference to the parent task. They also come in with different ID´s.
In the attached screenshot the green arrow is the parent and the red is the associated subtask.
@lpb Thank you!! Completely missed that column in the live data sheet.
Solution was so simple. Referenced “Parent Task” in the overview sheet and the added a simple filter to the column. Only Main task show now, so perfect!
