Standardizing Date Formats in Sheets to YY/MM/DD

The Date column's format is not consistent. My default regional setting is Korea, so I think the date should be displayed in the YY/MM/DD format. However, some Date columns appear in the DD/MM/YY format, while others are in YY/MM/DD. It seems that the default is the DD/MM/YY format, and the format of some Date columns changes after the Sheet is refreshed.
Even when I apply the Date format feature from the menu, it only appears in the DD/MM/YY format. Is there a way to unify them into the YY/MM/DD format?
Answers
-
Hi @홍은표
I suspect some of the shared users changed the date format.
I tested and found that an Editor can change the date format in a sheet. I expected that only Admins or above could change something that affects column definition, like date format. But it turned out that an Editor can.
This help article says that even an Editor can change the date format.
https://help.smartsheet.com/articles/2479481-apply-standardized-date-formats-in-your-sheet
Editors, Admins, and the sheet Owner can apply a date format in a sheet.
If you lock the date columns, you can prevent editors from changing the date format.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives