Date Fromat
Hi,
I was wondering how I would change the date format to USA to UK.
thanks in advance.
Best Answer
-
There are two ways that you can adjust date formats. If you want to configure how you view dates throughout your entire Account, you can set your own preferences in your Personal Settings. See: Specify Default Date and Number Formats With Regional Preferences
This setting is only for you, so if anyone else is looking at the same sheet, the dates will display based on their settings.
However, there is another way to adjust date format, to make sure that everyone looking at the sheet sees the same thing. This would be formatting the column itself directly in the sheet. See: Apply Standardized Date Formats in Your Sheet
Click on the column name to highlight the column, then select your date preference from the format toolbar:
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
There are two ways that you can adjust date formats. If you want to configure how you view dates throughout your entire Account, you can set your own preferences in your Personal Settings. See: Specify Default Date and Number Formats With Regional Preferences
This setting is only for you, so if anyone else is looking at the same sheet, the dates will display based on their settings.
However, there is another way to adjust date format, to make sure that everyone looking at the sheet sees the same thing. This would be formatting the column itself directly in the sheet. See: Apply Standardized Date Formats in Your Sheet
Click on the column name to highlight the column, then select your date preference from the format toolbar:
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
@Genevieve P. I have opted for the settings as I am based in the UK.
Once again thank you so much for your assistance.
I hope you don't mind me asking these question in this forum.😅
-
I'm glad I could help! It's no problem at all, that's what the Community is here for. 🙂
You may be able to find some of the answers to your questions directly in the Help Center as well: https://help.smartsheet.com/
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
@Genevieve P. Aww thank you i appreciate it and I am learning new things with Smartsheet's daily never knew it existed. I plan to work on this on the weekend will let you know how I get on. :)
Have a nice weekend 😃
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 376 Global Discussions
- 206 Industry Talk
- 437 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives