Exported data to Google sheets appears in different order each time

I’ve synced data from Asana to a google sheet and linked it to a pivot table in order to get “live” dashboard. Unfortunately the columns in the exported sheet end up in a different order after updating information in Asana.

How can I fix it?


Consider using a different tool to create the table / visualization. Some options include Google Data Studio, PowerBI or Tableau. With each of these you’ll be able to sort by date in a natural manner no matter the order of the data.

Hi there, I am facing the same problem, been using for a long time without problem, suddenly this week it started to show fields in different order randomly witch is breaking my PivotTable field selection