I'm having trouble figuring out a way to create a filter that I need for a list I've made. I need to filter a certain column based on the current user.
For example, if the current user is "John Doe", I only want to show items in the list where Shift = "A". If the current user is "Jane Doe", I only want to show items in the list where Shift = "B".
The only filters I have found are ones where the column matches the current user exactly. I don't know how to incorporate this third variable in getting my filter to work.