I'm trying to make an inventory list where we show who has been assigned a computer. What I want to see is a field that shows if a computer has been assigned to another person previously and the name of that user (column:Previous User) based on duplicates in the column:Serial Number.
I almost got this working using workflows but it would show the name of the current user. I'm not sure how to get it to identify only previous users. We have a "Date Assigned" column if that would be useful.
My next question is what if the computer was deployed 5 times, which item will the workflow find? Does it start from top to bottom in a workflow?