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!
My manager set up a weekly smartsheets attachment of a sheet to be emailed to them every week. She now wants to turn this off but when her and I go into the Send as Attachment section of the page it only shows that two were sent instead of weekly for the last year or two and there is no way to turn anything off. How do I…
I have a large master sheet that I do not want anyone to have access to except the small team of admins. Is there a way for everyone in a dept to see the projects their dept are involved in (this is defined by a column), but only the PM can make edits to it? Bonus points if we can sort by "Status" then by "Kick-Off Date".…
Is there a way to have a master report that is pulling in the data from all of the necessary sheets and then several minor reports off this one where certain rows can be shown in certain sheets? The reason for this is because as projects get created in the workspace the admin then has to go into 5 reports and link the new…
