Formatting Numbers as Text, Apostrophe in Dates
Is anyone else having the issue with Supermetrics for Google Sheets where downloads randomly format dates and numbers as text? We have been seeing this issue a lot lately and it causes problems with formulas that rely on these data sets.
- All cells sometimes have apostrophe in front of the value (thus formatting all dates and numbers as text)
- Sometimes individual date or number cells are formatted as text, without the apostrophe. This is even harder to deal with since you have to find the exact cell to replace
At this point we've seen it across accounts, files and all traffic sources so it seems widespread. I've had a ticket open with support for 72 days now so opening this up to the public forum to see if others are having the same issue.