Usernames can have both Free and Busy status or only one type Free or Busy.
To make more clear this is example:
Username | Status
Peter Parker | Busy
Peter Parker | Free
Hal Jordan | Free
Clark Kent | Busy
Clark Kent | Free
Now I need a view to show only Hal Jordan as he is only one with unique status.
I know to do this with two WFs, one comparing usernames (in another list where are just usernames) for each item and then triggering another WF to update hidden column in next item so first WF can check that item next and so on, but it takes a year to complete and it needs to be refreshed on item created/changed.
Do you have any idea how to do this on easy way?
(exp. Like in excel when you can filter columns)
- Edited by DannyNS 12 minutes ago