Sign in to join the conversation:
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
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
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.
Duh! The new date formats. There is one that works exactly as the poster describes... Ugh.
Exactly, Duh is the word!
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
@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.
Wow, awesome Paul! Thanks!
I have a sheet set to notify myself and another user when ANY CHANGE is made to the sheet. Neither of us received the notification. Any suggestions on why this is not working? It has been a while since this form was used, but it worked previously.
My reminder in smartsheet automation is set to trigger every day starting 12/05/2025 at 8am (gmt+1) and the condition is to send the reminder to the contact in the contact list if the reminder flag is set to 1 and the status is not one of DONE. Currently on the sheet, a task has the reminder flag set to 1 and the status is…
Hi Everyone, My IT has a lot of confusion on what we access we really need to have for certain people. What is the difference between a "Member" and a "Licensed User?" We have a lot of sheets that have owners who do all of the changes of the sheet. I know that they need to be licensed users. But then, we have a lot of…
