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

How to create a formula to pull the first part of an order number into an adjacent column
Hello! I am struggling to create a formula to pull the first part of an order number (our internal agency numbers) into a separate column so I can see how much each agent sends in each month. Screenshot of the order number below:
Countifs date is this month and a day of the month
Hello all, I am using the formula to count from a list of dates in another sheet to find all entries that are from this month. =COUNTIFS({Date}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Bay}, Bay@row) I would like it to also register if it is the 1st of the month (for the column named 1st) and the 2nd of the month (for…
IF Statement to Display Symbols
Formula variable question for an IF Statement. Ok I have 5 columns (see screenshot below). This formula will be added to the one on the far right (Certification Complete). Now I would like to assign a value to each to trigger the symbol that will display. Basically the way it works is that all 5 columns are required, if…