Date format - Cell linking


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:





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!