I have a scenario where I want to divide a list's items into 2 webpart views - one that shows only the x oldest items (people that should be seen next) and another list on the same page showing the remaining items. This is like a "you are next" application that will display the people waiting and queue some to the top that were here first and are "ready" to be seen. How do I accomplish this? Not sure how to create the criteria that will update each time something in the list changes / is removed - and exclude those designated as the top 3 without replicating them. Please help!
You need two separate web parts. For the first, Edit Web Part > Edit the Current View >
- Sort by Created By / filter by some sort of open value
- Item Limit = 3
For the second one, there is no way (without doing some custom code) to show just the remaining records. You'll have to show the whole stack in the other one, sorted as you'd like.