FIltering a list I have a problem regarding ...

(Iomar Mercado) #1

FIltering a list

I have a problem regarding filtering.

I have two tables, one which basically list all the “days” of the year like: 2/28/2018 3/1/2018 3/2/2018

The other table list volunteers availability. I have a different column for each day. For example

NAME

Monday

Tuestay John Doe

yes Jane Doe

yes

I manage to filter Mondays with this formula:

SELECT(LocalVolunteers[ComputedName],AND([TRC]=LocalVolunteers[TRC], WEEKDAY([WEEK])=2, ISNOTBLANK(LocalVolunteers[Available on Monday?]))) However it’s a challenge to list the volunteers for Tuesdays, ect.

Any ideas??

(Aleksi Alkio) #2

Do you have a date on your volunteer’s table at all? Or is the case like this… if the date is 2/28/2018 (Wed), read only Wednesday statuses?

(Iomar Mercado) #3

@Aleksi_Alkio

No, just the date.

(Aleksi Alkio) #4

I believe you mean Day?