Is there an easy way just to list Month and Year with no Day?

Graham Rimell

I'm wanting to list Months within a date column.

Jan 2020

Feb 2020

March 2020

etc

I can do this in the date column, but it seems to insist on showing the day as well. Does a date option exist to show just month and year?

Excel has a feature were you can have custom date formats, and pick MM,YYYY. Does this functionality exist somewhere within smartsheet without having to make complicated tables and formulas?

Andrée Starå

Hi @GrahamR

Yes, you can change how it’s shown in the column from the menu on the far right (Date Format).

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or 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!

Graham Rimell

Thanks.

Unfortunately that option is not available. All of the options list the Day. No MM/YYYY option.

Andrée Starå

@GrahamR

Ah, yes, sorry about that. I thought that option was there.

Please submit an Enhancement Request when you have a moment