Auto-date format not changing

Pal Brezovay · 02/15/21

Hello!

I'v created auto-numbering columns for creation and modification dates, the default format is MM/DD/YY HH:MM

I'd like to change it to show only the date, not the time (to YYYY/MM/DD to be exact, but getting rid of the hours and minutes would be also good enough). I select the whole column, and in the toolbar the date format, and then the wished format. And nothing happens.

I tried it with a generic date column, works fine on that.

Any idea why the auto-number dates are not changing? Is it set to that format without the option to change it? Sorry if the topic already exists, I tried searcing but couldn't find it.

Thanks

Pal

Heather Duff · 02/15/21

Hi Pal,

I have had the same problem! I am curious to see if anyone has a solution.

Thanks,

Heather

Sunil Kadikar · 08/16/21

Same problem here. Is there a solution to this?

Andrée Starå · 08/16/21

Hi @Sunil Kadikar, @Pal Brezovay & @Heather Duff

I hope you're well and safe!

Unfortunately, it's not possible now because it's a system column (Created or Modified), but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Here's a possible workaround or workarounds

You'd need to add a so-called helper column to show it without the time part.

Would that work/help?

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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Julie Barbeau · 11/02/21

Hi, someone can explain me how you have date format with hour and minutes?? I want to have this but my date format show only date. Do you have a special version of smartsheet?

Andrée Starå · 01/09/22

Hi @Julie Barbeau

I hope you're well and safe!

How did it go? Did you manage to get something set up?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

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

Pal Brezovay · 01/10/22

https://community.smartsheet.com/discussion/comment/309653#Comment_309653

Hi Julie,

I've tried and it seems to me, that it's only for auto-number columns (created and modified), not on any other date columns.

Pal

Auto-date format not changing

Answers

Categories