Hmmm, looking at your query I am frustrated at the lack of information and misinformation you are supplying to us.
You have told us that you are swapping around the column headings in Google sheets and that syncing in appsheet then makes the data go crazy…I reckon this would be normal behaviour. If you change any column headings or column names in your Google sheet, them you MUST refresh the table in appsheet…this is not the same as syncing the data.
If you are indeed doing the above then I apologise for getting it wrong.
Now then, the next part I find confusing is you are referring to a List view which I interpret to mean Table view. this table view should look the same sort of array of cells and values as your Google sheet…that is there will be column names with rows of data under them,
But…you refer to the view as putting column C first and then putting column B UNDER it…which makes me think this is a Deck view, unless you are using Table with a Group By option selected…
Then you say that when you change values in the Sheet and resync appsheet that all the values in appsheet change…appsheet will NOT read any changes you make in the Sheet until a sync is completed…which means if you add or subtract data from the sheet and sync then of course those changes you made will suddenly surface in appsheet.
Also, your label keeps changing? Labels don’t really have a purpose until you are using multiple sheets that are related to each other some way. It is what shows instead of the 8 character string of random looking letters and numbers from the ID…you have set a unique ID for your data yes?
Maybe we could help you more if you told us a little more about your sheet layout…how many columns does it have? Are there related sheets where the ID and Label come into effect?
Hope you can shed some light