Wrong date format on hyperlinks

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?

Tom

Find more posts tagged with

Project Management

Cell linking

Comments

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.

egdk

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

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.

Chris Warren

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

Richard Golstein

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

Hi,

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

Sign in to join the conversation!

Quick Links

Trending discussions

Automated email with number of pending records
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
License Question
I already have a Smartsheet license with my company, but I was recently invited to collaborate on a sheet owned by another group within the same organization. When I accepted, I was told I need to upgrade in order to edit or contribute. Can you please explain why this is required? It seems unreasonable to need multiple…