I was wondering how I would change the date format to USA to UK.
thanks in advance.
Hi @Majid Kayani
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:
@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/
@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 😃
Apologies if this has been previously discussed or in support already. Is there a way to get smartsheet to send an email notification in say 1 month based on the date entered in the cell? i.e. Went to a building site on the below date... smartsheet automatically sends me an email reminder in 1 month from this date to alert…
Hello, I am currently attempting to organize my files in Workspace by creating folders to group them. I am doing this by dragging and dropping sheets from the 'Sheets' folder into my 'Workspace' folder. However, some sheets that I own and created do not appear in the 'Sheets' folder. I even tried editing some details in my…
The number of Unlicensed Users was listed previously under User Accounts. Why is it no longer there?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.