Format Date

NSanchez90676 · 07/26/19

Is possible to declare one custom date format for a column and another format for another column using smartsheets?

NSanchez90676 · 07/26/19

by the way I would like to see the birthdays as mmm - dd instead mm/dd/yyyy

Andrée Starå · 07/26/19

Hi,

If you click on the icon on the far right in the toolbar, you can change the date format.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Amarjyoti Dutta · 02/17/20

I would also like to know if it's possible to format a date in a custom format, say only as YYYY, which is not available as one of the options currently.

Andrée Starå · 02/21/20

Hi Amarjyoti,

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome · 02/21/20

@Amarjyoti Dutta While there is not a built in format for YYYY, you can use the formula of

=YEAR([Date Column]@row)

to generate the 4 digit year.

Format Date

Comments

Categories