I'm trying to set up a view to filter on column Status (options are "WIP - Drafting", "Eng Check" and "Peer Check") and the name in columns "Drafter", "Eng" or "Peer".
Any one of the engineers could be the drafter, engineering checker, or peer checker. I need to apply a filter "WIP - Drafting" and "Drafter" = username OR "Eng Check" and "Eng" = username OR "Peer Check" and "Peer" = username.
I've tried adding a calculated field to combine Status and Eng, Drafter, or Peer, but I can only select Status. I cannot use the other columns because they select from the user pool instead of typing in plain text.
Any ideas how I can get this to work?
EDIT Not sure how to bump this or if the question isn't clear. Anybody?