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
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives