Date format on charts

Hi there,

I want to track the amount of tasks / date. When I convert my report summary into a chart I think the dates are reformated into numbers.

My data set looks like this:


And my Chart looks like this:


As you can see there is an issue with the date format... I've tried everything but couldn't find a solution.


Thanks for your help,

Best Answer

  • Paul Newcome
    Paul Newcome Community Champion
    Answer ✓

    This is a known issue. I just got the below update from support about 6 hours ago...


    "By looking at the screenshots you’ve provided, I recreated a similar report to test the Chart behaviour with and was able to replicate the issue. It looks like that when the report is grouped by a Date -column and summarised, the date is displayed in Unix Time instead of Date/Time as in the source. This does not look to be expected behaviour and therefore I’ve escalated the case to be reviewed by our Senior Resources team. They will engage with the Engineering team responsible for the Chart widget development to confirm the behaviour. We will let you know as soon as we have any updates regarding this. "

Answers

  • Paul Newcome
    Paul Newcome Community Champion
    Answer ✓

    This is a known issue. I just got the below update from support about 6 hours ago...


    "By looking at the screenshots you’ve provided, I recreated a similar report to test the Chart behaviour with and was able to replicate the issue. It looks like that when the report is grouped by a Date -column and summarised, the date is displayed in Unix Time instead of Date/Time as in the source. This does not look to be expected behaviour and therefore I’ve escalated the case to be reviewed by our Senior Resources team. They will engage with the Engineering team responsible for the Chart widget development to confirm the behaviour. We will let you know as soon as we have any updates regarding this. "

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!