Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Hi There, Date Format / showing day name or initials
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
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
-
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?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Duh! The new date formats. There is one that works exactly as the poster describes... Ugh.
-
Exactly, Duh is the word!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
-
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.
-
Wow, awesome Paul! Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.5K Get Help
- 466 Global Discussions
- 156 Industry Talk
- 510 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Hi Smartsheet superusers! Ok, so I used Smartsheet with a previous employer for a few years and it's been about two years since I was really working in the system. My potential new employer uses it an…
- I have data on a "copy of construction checklist" that has been shared to me. I am an admin to the shared copy of construction checklist. If the owner of the sheet, cycles data off the sheet due to co…
