Hi There, Date Format / showing day name or initials

M Alsaqqa · 07/23/19

Hi All,

I wonder if there is a way to make the Day initals (i.e. Sat, Sun, Mon...etc) show up next to the date in smartsheets?

Regards,

M Alsaqqa

Andrée Starå · 07/23/19

Hi,

Unfortunately, it's not possible at the moment to get in the same cell, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

As a workaround, you could add a column and have it show there.

Would that work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome · 07/23/19

It also depends on how the dates are entered. If manually, Andree's suggestion will work. If you are using a formula, you could add to it, but it would then render the date useless for future calculations.

Andrée Starå · 07/25/19

I just realized that you could change the format of the date and at least include the name of the month or day.

Would that work?

Paul Newcome · 07/25/19

Duh! The new date formats. There is one that works exactly as the poster describes... Ugh.

Andrée Starå · 07/25/19

Exactly, Duh is the word!

Rodney Myers · 01/28/20

Column you want the Initials =IF(WD1 = 1, "Sun", IF(WD1 = 2, "Mon", IF(WD1 = 3, "Tues", IF(WD1 = 4, "Wedy", IF(WD1 = 5, "Thu", IF(WD1 = 6, "Fri", IF(WD1 = 7, "Saturday", "")))))))

Helper Column WD =WEEKDAY([Date]1)

DATE Column

Paul Newcome · 01/28/20

@Rodney Myers

You could also combine your two columns into 1 to save a little space if needed...

=IF(WEEKDAY([Date]@row) = 1, "Sun", IF(WEEKDAY([Date]@row) = 2, "Mon", IF(WEEKDAY([Date]@row) = 3, "Tues", IF(WEEKDAY([Date]@row) = 4, "Wedy", IF(WEEKDAY([Date]@row) = 5, "Thu", IF(WEEKDAY([Date]@row) = 6, "Fri", IF(WEEKDAY([Date]@row) = 7, "Saturday", "")))))))

Just use the WEEKDAY function directly in your nested IF's.

Ross Brown · 10/07/20

https://community.smartsheet.com/discussion/comment/191376#Comment_191376

Wow, awesome Paul! Thanks!

Hi There, Date Format / showing day name or initials

Comments

Categories