Google Sheets/Asana Integration - Data is Rearranging

googlesheets

#1

I’ve been having an ongoing issue of my data rearranging in Google Sheets. It’s occurring on a sheet where I am referencing live source data from another sheet (ex. =‘Live source data’ !A21) and have also added in additional columns. Every time I try to sort or filter the data, everything looks fine but then a couple of days later it’s all rearranged again.

We use the project management tool Asana and the reporting integration with Google Sheets is where I am referencing the live source data from.

Can someone please assist? This is driving me insane and really hurting our reporting capabilities. Thank you!