Day of the week
What formula do I need to turn a date in one column to the day of the week in another
So what I'm after is 09/06/22 = Thursday and so on
I'm new to Smartsheets, but I can do this in excel. Please help I think I'm goning nutts
Best Answers
-
Hi @Jo Pearson
I hope you're well and safe!
Try something like this. (change the column name if needed)
= IFERROR( IF(WEEKDAY(Date@row) = 1, "Sunday", IF(WEEKDAY(Date@row) = 2, "Monday", IF(WEEKDAY(Date@row) = 3, "Tuesday", IF(WEEKDAY(Date@row) = 4, "Wednesday", IF(WEEKDAY(Date@row) = 5, "Thursday", IF(WEEKDAY(Date@row) = 6, "Friday", IF(WEEKDAY(Date@row) = 7, "Saturday"))))))), "")
Did 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!
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.
-
Hi @Jo Pearson,
as André already posted an example of the usage where your dates can be found in a column named "date" and the WEEKDAY formula lives in another column to show the day of the week, maybe you could post a screenshot so we can see?
Greetings
Stefan
PS: André also incorporated an IFERROR function in his example to cater for empty cells in the "date" column :-)
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
Answers
-
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
Thanks Stefan, I've tried and it doesn't work
-
Hi @Jo Pearson
I hope you're well and safe!
Try something like this. (change the column name if needed)
= IFERROR( IF(WEEKDAY(Date@row) = 1, "Sunday", IF(WEEKDAY(Date@row) = 2, "Monday", IF(WEEKDAY(Date@row) = 3, "Tuesday", IF(WEEKDAY(Date@row) = 4, "Wednesday", IF(WEEKDAY(Date@row) = 5, "Thursday", IF(WEEKDAY(Date@row) = 6, "Friday", IF(WEEKDAY(Date@row) = 7, "Saturday"))))))), "")
Did 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!
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.
-
Hi @Jo Pearson,
as André already posted an example of the usage where your dates can be found in a column named "date" and the WEEKDAY formula lives in another column to show the day of the week, maybe you could post a screenshot so we can see?
Greetings
Stefan
PS: André also incorporated an IFERROR function in his example to cater for empty cells in the "date" column :-)
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
This content has been removed.
-
Just tried Andree's post and it worked perfectly. Thanks!
-
Hi, i'm new to smartsheets and was looking for a solution like this but am unsure how to implement it on my sheet…
I assume I need a column with the date to draw from but how and where would I use Andre's solution? -
Hi,
I hope you're well and safe!
You're correct, and then you'd add my formula in a so-called helper column.Make sense?
Did that work/help?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!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.
-
I'm still working on this… Let me give some context of what i'm trying to do.
I am working on a dashboard with a frame that shows assigned tasks for a user. I'd like this to change based on the day of the week. We have a series of reports that displays these for each day of the week. Basically I would like the frame to automatically load a specific report depending on the day of the week. So Monday the dashboard frame loads report A and Tuesday Report B and so on. I work in research animal husbandry and we use smartsheets to create our technician animal room assignments and our techs open these reports manually now from links posted on the current dashboard.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!