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

Find more posts tagged with

Accepted answers

Mark Cronk

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

Mark Cronk

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

All comments

Mark Cronk

Hi @Kelsey Ciarrocca ,

Try:

Mark

Kelsey Ciarrocca

https://community.smartsheet.com/discussion/comment/271531#Comment_271531

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.

Mark Cronk

Good evening @Kelsey Ciarrocca ,

It was missing a paren to close the first WEEKDAY. Try this:

Mark

Kelsey Ciarrocca

@Mark Cronk THANK YOU!! That worked!

Mark Cronk

Happy to help. Thanks for using the Community.

Mark

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.