Formula not working in some cells of column

I ran into an odd situation where the formula I am using is not working in some cells. I tried using this as a column formula (How I would prefer). I also tried it as a cell formula. But I have random rows where the formula simply refuses to work.

This is the formula in question. It should fill in the Additional assignment column with the assignment for the given day. But it's randomly not filling in the info.

=IF(WEEKDAY(TODAY()) = 1, Monday@row, IF(WEEKDAY(TODAY()) = 2, Tuesday@row, IF(WEEKDAY(TODAY()) = 3, Wednesday@row, IF(WEEKDAY(TODAY()) = 4, Thursday@row, IF(WEEKDAY(TODAY()) = 5, Friday@row, IF(WEEKDAY(TODAY()) = 6, Saturday@row, Sunday@row))))))

Find more posts tagged with

Formulas

columns

Accepted answers

prime_nathaniel

@gwilkinson traditionally for day of week sunday is 1. Please verify with a date and dayofweek column. In non SMAR its 0-6. Either way monday is almost never the first index of the system unless there is an explicit override for it

gwilkinson

You nailed it. I had my other weekday helpers all starting on Sunday and formatted this one for starting Monday. I just fixed it and it seems to be working.

=IF(WEEKDAY(TODAY()) = 1, Sunday@row, IF(WEEKDAY(TODAY()) = 2, Monday@row, IF(WEEKDAY(TODAY()) = 3, Tuesday@row, IF(WEEKDAY(TODAY()) = 4, Wednesday@row, IF(WEEKDAY(TODAY()) = 5, Thursday@row, IF(WEEKDAY(TODAY()) = 6, Friday@row, IF(WEEKDAY(TODAY()) = 7, Saturday@row))))))

All comments

gwilkinson

OK… From what I can tell it seems to be working 1 day ahead of itself. The formula is populating the cells with the friday assignments and not thursday. Where did I go wrong on this formula, did I number the days incorrectly?

prime_nathaniel

gwilkinson

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.