We have a Sharepoint list which contains a user's name, various areas of duty, and the weekday name for that roster. For example:
Name Recess Lunch Day
Joe Area 1 Area 3 Monday
Fred Area 4 Area 2 Tuesday
Is there a way to filter this list based on the Day column? We've tried modifying the view to select items where Day = TEXT(Today,"dddd"), however that did not return any records.
The data is not likely to change much, but we do need to be able to modify an individual record in special cases such as relief staff members etc.