Day of the week

Jo Pearson

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

Andrée Starå

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!

Stefan

Hi @Jo Pearson,

https://community.smartsheet.com/discussion/comment/332398#Comment_332398

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 :-)

Stefan

Hi @Jo Pearson,

I think the WEEKDAY function is your friend ;-)

https://help.smartsheet.com/function/weekday?dlm=111

Hope this helps

Stefan

Jo Pearson

Thanks Stefan, I've tried and it doesn't work

Andrée Starå

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!

Stefan

Hi @Jo Pearson,

https://community.smartsheet.com/discussion/comment/332398#Comment_332398

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 :-)

Unknown

This content has been removed.

Anan

Just tried Andree's post and it worked perfectly. Thanks!

gwilkinson

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?

Andrée Starå

https://community.smartsheet.com/discussion/comment/442816#Comment_442816

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!

gwilkinson

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.