A part of my workflow writes the items over to another list where users can see their outstanding invoices that need approving. However, the workflow logic goes, the filter only proves false and the item disappears at the end of the entire workflow.
I have the user list filtered based on if the choice column is set to "Open" and if my user profile is set as one of the 3 reviewers. Otherwise, if this condition is not met, the item is not on the list.
I am trying to figure out some way that the item will only stay on the list when it is assigned to the current reviewer. I attempted to do this by adding additional choice columns and then changing the status of that column after each user is assigned, and then closing/updating once the approval is made. However... when I go to modify the list and setup filters, there is no grouping so it only judges by what it reads.
[Item Status] is equal to Open
[Reviewer 1] is equal to [Me]
[Item Status 2] is equal to Open
[Reviewer 2] is equal to [Me]
[Item Status 3] is equal to Open
[Reviewer 3] is equal to [Me]
If the filter was just looking for the Item Status to be open and the reviewer to be me, then the item would work fine, but when it sees other "ands" in the statements, it considers it to be false since it doesn't meet the conditions.
Does anyone have any suggestions, or maybe ideas on shading the line item a different color or using an indicator once the item has been approved?