Dates and months issue
Are there others or many experienceing issues that Smartsheet swaps months to dates and vica versa?
I have now had this issue several times and informed SS about it. For some reason the issue goes away after letting SS know (maybe they do something) about it but then it comes back after a month or so. This has now happend three or four times at least. It's not optimal making my monthly reports wrong.
This issue happens with control center. We have a weekly status update sheet where every new week has a new row. The summary section searches the newest record/row and collects all data from that week to sheet summary section. From summary section the metadata is collected to master/blueprint summary sheet that collects the data from all projects. The final portfolio report is made from the master summary sheet.
It seems the data or date is still correct at the sheet summary section (the date is converted to text/number as it is metadata) buth the month and data is swapped when it goes from summary section metada to master summary sheet (a date column).
The challenge is that this happens only for some projects and not always. It seems to happen for projects that even have same date format (european) that when i'm seeing the report (european date).
Is this a known issue with control center or am I the only one? How could this issues be eliminated?