Our team’s projects need far more rows than 250. I saw in another thread that the cvs export limit issues has been addressed but the limit to sync is still an issue. I would like to use the sync to automate our reporting process but this limit makes this impossible. Any ideas?
5 Likes
You are referring to the Portfolio <> Google sync?
The limit for the number of projects in a portfolio should now be 500, maybe the sync also works for 500?
Hi Bastien,
We use a project in place of a program because Asana doesn’t have programs. This workaround means that each “task” in our Asana solution is a project. I have a program with hundreds of tasks (projects) that I wish to sync. Make sense? I wish to automate the extract for a number of reasons but since the sync truncates at 250 at the project level I’m suck exporting.
~Meg
Then which sync are you talking about?
The Project<>Sheet sync that you could ask the support to set up is going away, is this the one?
You could use Zapier to recreate the sync, I built a prototype for a client recently.
It’s the export > sync to Google sheets feature. It is truncating to 250 rows. Most projects have more than 250+ tasks so would be good to have the ability to export and sync the full project.
3 Likes
What should we do on this cases where we got more than 500 bus still getting the truncated error?
3 Likes
I am also using this auto sync with google sheets and my data is truncating at 500 rows.
1 Like
I’m seeing the same thing on my project. May I know why the records are truncated? It’s a huge handicap right now.
4 Likes
Coming to you from 2024…
Is there a way to remove the truncation feature? It is still capped at 500 rows.
3 Likes
No, that’s still the Asana product limit. See item 7.4 here:
1 Like
Please more than 500 rows 
4 Likes
I want no limit
I create over 700 tasks a month
Hmm, this is a problem for me too. Why have this feature then limit it to x number of rows? I have well over 500 projects in the report I export to Sheets so the charts etc. I created are redundant. Great job, Asana.
1 Like
Is anyone able to explain how the Truncated at 500 rows works. i.e. how is it deciding what is synced and what is not, as I’ve got task IDs ranging from low 10s through to 1700s pulling through. Or is it that long standing completed tasks are filtered out 
In addition to just a flat row count increase, more control over which rows (i.e. only tasks where X is true, or no subtasks) are included in the range would be a boon!
1 Like