Date format - Cell linking

Daniel Kumar

Hi,

When I try to cell link a date column it changed the date format from:

dd/mm/yy to mm/dd/yy.

The strangest thing is that it did not happen most of the rows, but some random ones.

I have tried to refresh the sheet several times, but I still get the same date errors. Do anyone have any idea or suggestions in order to fix this issue?

I have attached what I see when I mark the cell and look at the viewed cell. As you can see, the error is also there:

Best,

Daniel

SolutionSal

Hello, are you familiar with the Date Format Button located within the toolbar?

https://help.smartsheet.com/articles/2479481-apply-standardized-date-formats-in-your-sheet

My hunch is one sheet uses a date format which doesn't match the other. Try double checking that both sheets or columns use the same format. Hope this helps!

Daniel Kumar

Hey,

I have not seen this before, but its the same format on both sheets. As mentioned, it is correct in most rows, but not every row.

Best,

Daniel

Danny.B

I am having the same issue when linking dates. These are linking to the Created Date column of different sheets. Some are formatting correctly, others are not. I do not know why one would be different than the other.

David Sakko

I'm having similar issues - it's driving me up the wall! DOes anyone have a solution to this?

Cheers, David

Maik Neubauer

I have had the problem for a long time. As soon as a formula uses a date, it is constantly changed in type by Smartsheet. As soon as a user is logged in, it is written back to the regional version. It is extremely annoying because the changed date is always overwritten.

Maik Neubauer

I now use a workaround because Smartsheet does not work properly. A bit complex but it works. I create a unique number for the date and use it later in the formulas. So the date is no longer automatically changed in the formatting.

Formula:

=DAY([date (from)]@row) * MONTH([date (from)]@row) * YEAR([date (from)]@row) * YEARDAY([date (from)]@row) - DAY([date (from)]@row) - MONTH([date (from)]@row) + YEAR([date (from)]@row) - YEARDAY([date (from)]@row) - WEEKDAY([date (from)]@row) - WEEKNUMBER([date (from)]@row) - YEARDAY([date (from)]@row)