nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Format Date

NSanchez90676

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

Find more posts tagged with

Comments

NSanchez90676

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

Andrée Starå

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

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å

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

@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.

Sign in to join the conversation!

Quick Links

Trending discussions

Created Date Time Stamp
Has anyone figured out a way to use a column as a created date but not have the time stamp? It causes problems for my manager trying to use that date to pull into PBI. I know how to convert in a helper column to a year-month and a year, but those have to be text/number columns, not date columns and he can't use those…
How to auto populate cells
I am looking for a way to automate a cell so that when column A displays 9 'Days Open' (or between the values 0-14) the 'Req Age' will auto populate (or trigger) the ranges provided. Image below: I want the highlighted section to auto populate based on the value in 'Days Open'
Why Can't I no Longer Able to add Folders, Sheets, or Reports in my "Sheets" folder
Good morning, I haven't needed to do this is quit a while but I went to clean up the "Sheets" folder in my account and can no longer create a folder, sheet, or report in any area of that folder. The "Create" button at the top right takes me the templates page. This is what I am seeing vs what I can do within a workspace.…