Wrong date format on hyperlinks

TomG! ✭✭
edited 12/09/19 in Smartsheet Basics

Hello all, 

I have searched this topic but can't find anything. I'm using UK date formats in my companies sheets and our account is set-up in UK format, however when I link a date from the source sheet into the new sheet the date is displayed in US date format.

Is this a glitch or are we doing something wrong?



  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Perhaps your personal settings are set to US? Each user has their own personal settings. User Menu > Personal Settings > Settings... are those settings set accurately? Both the timezone and Regional Preferences? If so, I would recommend contacting support. 


  • I have the same problem, only one user, one format, and still this is chaged to US format.. why?

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    That is a strange event. I would contact support and let them know about the issue. Please reference this thread, and come back and post your discoveries here. 

  • This is an old thread but was this ever resolved ? I am having the same problem :(

  • I am hitting the same issue, i am trying to use contol center and this creates a cell link, however its using US format on the destination sheet vs GMT which is on the source sheet. This is rather frustrating. I think this is a bug that still exists. I'll be logging a ticket for this.

  • Chris Kaliveas
    Chris Kaliveas ✭✭✭✭
    edited 04/26/21


    I encountered this issue too. The cause of my instance is the target link cell was not in Date format and was Text. Even if I changed the format to Date, the value would retain US format. I added a new column next to the bad column field and moved the links into it and whala, it worked (be carefull...500 row limit on moving). Then I moved the links back to my original column and worked. So, be sure to format the destination column correctly before linking.

    fyi @Chris Warren