Step 1: Has your date column been selected to be the first column in the sheets?
The date range column should always be the first column and not in the middle of the sheets, especially when there is another column next to it that resembles numbers as well.
Wrong example :
Step 2: Are your metrics segmented into separate columns?
Make sure your sheets have each metric separated into different columns on the horizontal side, not the vertical, otherwise the report will treat dimensions and metrics incorrectly.
If this does not take care of the issue, please get in touch with us via live chat and we can get to the root of the problem!