Formula not working in some cells of column

gwilkinson

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

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

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