Filter Functions Missing 3rd Value in List

Unsolved

Hi everyone, I am using the following function to list the names of all of my direct reports (EA = column of all names) who are scheduled for a shift each day of the week:

=filter(EA,Wk1.Sun<>"Request Off",Wk1.Sun<>"off",Wk1.Sun<>"n/a",not(isblank(Wk1.Sun)))

Wk1.Sun is the column adjacent to the name column (EA) with everyone's shifts for the first Sunday of the pay period. Shifts can be all different times and so I'm just trying to exclude anyone who is not scheduled. The text in quotes are all the options which would indicate that they are not working that day. This function used to work properly, but I recently changed the "n/a" option (used to say "camp") and added "Request Off", so I updated the function but now it will list all the correct names, except it will skip whoever would be third in the list. All the days of the week do this and it's not the same row or the same shift times, only whichever name should be listed third is just left out of the list.

I've tried only adding one condition at a time and it still misses whichever name should come up third in the list.

Does anyone know what is happening here and how I can fix it? Thank you!

Posted Jan 11, 2026, 8:15 PM UTC

05
Loading comments…