Iโm looking for help on filtering a view. So far I successfully filtered the view based on User. Iโd like to filter it further based upon what day of the week it is. I have a service route for my employees to follow, they have reference data that doesnโt change and is recurring. However they have different routes for different days. Iโve added a โService Dayโ column where I would like the sliced view check if that is todayโs day of the week. If today is Wednesday, show only the rows that have Wednesday in the โService Dayโ column. Any and all help would be much appreciated.
I was using this reference earlier when trying to add the filter, but it wasnโt working.
I added it with the IFS function being
AND([Tech]=USEREMAIL(),[SERVICE DAY]=WEEKDAY(Today()))
It wasnโt workingโฆ In the Service Day column do I put โWednesdayโ or โ4โ?
Alsoโฆ I set the โSERVICE DAYโ column type as Date. Does that need to be something else?
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |