0 being added to my weekdays
Hi all!
I'm trying to list the weekday (using WEEKDAY) based off my date field. It's so weird though, I'm getting a "0" added at the beginning of every day besides Monday and Sunday. Does anyone know how I can fix this?
I tried using "&" and "," instead of plus signs, but that didn't work.
=IF(WEEKDAY([Calendar Date]2) = 1, "Sunday") + IF(WEEKDAY([Calendar Date]2) = 2, "Monday") + IF(WEEKDAY([Calendar Date]2) = 3, "Tuesday") + IF(WEEKDAY([Calendar Date]2) = 4, "Wednesday") + IF(WEEKDAY([Calendar Date]2) = 5, "Thursday") + IF(WEEKDAY([Calendar Date]2) = 6, "Friday") + IF(WEEKDAY([Calendar Date]2) = 7, "Saturday")
Best Answers
-
Hi @Kelsey Ciarrocca ,
Try:
=IF(WEEKDAY([Calendar Date]@row = 1, "Sunday", IF(WEEKDAY([Calendar Date]@row) = 2, "Monday", IF(WEEKDAY([Calendar Date]@row) = 3, "Tuesday", IF(WEEKDAY([Calendar Date]@row) = 4, "Wednesday", IF(WEEKDAY([Calendar Date]@row) = 5, "Thursday", IF(WEEKDAY([Calendar Date]@row) = 6, "Friday", "Saturday"))))))
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Good evening @Kelsey Ciarrocca ,
It was missing a paren to close the first WEEKDAY. Try this:
=IF(WEEKDAY([Calendar Date]@row) = 1, "Sunday", IF(WEEKDAY([Calendar Date]@row) = 2, "Monday", IF(WEEKDAY([Calendar Date]@row) = 3, "Tuesday", IF(WEEKDAY([Calendar Date]@row) = 4, "Wednesday", IF(WEEKDAY([Calendar Date]@row) = 5, "Thursday", IF(WEEKDAY([Calendar Date]@row) = 6, "Friday", "Saturday"))))))
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @Kelsey Ciarrocca ,
Try:
=IF(WEEKDAY([Calendar Date]@row = 1, "Sunday", IF(WEEKDAY([Calendar Date]@row) = 2, "Monday", IF(WEEKDAY([Calendar Date]@row) = 3, "Tuesday", IF(WEEKDAY([Calendar Date]@row) = 4, "Wednesday", IF(WEEKDAY([Calendar Date]@row) = 5, "Thursday", IF(WEEKDAY([Calendar Date]@row) = 6, "Friday", "Saturday"))))))
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Hi @Mark Cronk , I tried this and got #INCORRECT ARGUMENT SET. Any other ideas? I tried changing what I had to @row, and I'm still getting the 0's.
-
Good evening @Kelsey Ciarrocca ,
It was missing a paren to close the first WEEKDAY. Try this:
=IF(WEEKDAY([Calendar Date]@row) = 1, "Sunday", IF(WEEKDAY([Calendar Date]@row) = 2, "Monday", IF(WEEKDAY([Calendar Date]@row) = 3, "Tuesday", IF(WEEKDAY([Calendar Date]@row) = 4, "Wednesday", IF(WEEKDAY([Calendar Date]@row) = 5, "Thursday", IF(WEEKDAY([Calendar Date]@row) = 6, "Friday", "Saturday"))))))
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
@Mark Cronk THANK YOU!! That worked!
-
Happy to help. Thanks for using the Community.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!