Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Convert date format to mm/dd/yyyy

David Skinner

David Skinner ✭

11/29/16 edited 12/09/19 in Archived 2016 Posts

Is there a setting or a formula to convert the standard yy in smartsheet to yyyy?

Tags:

0 ·

Comments

Tomasz Giba - Fabmet ✭

11/29/16 edited 11/29/16

Go to Account => Personal Settings
Profille and change Language (Country) to English (Malta)

0 · Share on Facebook Share on Twitter
J. Craig Williams ✭✭✭✭✭✭

11/30/16

Wow. That's awesome.

I want to go to Malta.

Craig

0 · Share on Facebook Share on Twitter
David Skinner ✭

11/30/16

Thanks!!

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Action item Tracker with 2 way sync for selective items
I would like to manager a Master Action Item Tracker, but there are some items on the list that are confidential. Is there a way for me to create a duplicate of that action tracker for selective rows and for my team and I to colloborate on updating status between the Master and duplicate tracker and have the updates feed…
Need help with a cross-sheet reference formula.
I am trying to create a cross-sheet formula so I can count the number of projects for a specific PM where the show start data is in the month of January and year is 2024. The source sheet contains show start dates that are in 2025 so I want to be able to avoid counting them by mistake. I'm basically trying to count the…
Auto Number Formula Help - Add Project Code as Prefix
Hello, Is there a way to create an auto-number system to show [Project Code]-P-[AutoNum] where the auto number references the project code in the same row? Here's an example to illustrate: But when I try to add this prefix system to the Auto Number column properties… [Project Code]-P- types it literally… "[Project…