I have a list that I need to view in a certain way. I have date required and priority level columns. I need the view to be set so that when two users put a request in for the same date required, it will have the higher priority one first. If they have the same date required and priority level, then its fine.
How do I make this happen? I tried sort but it only sorted by date. I created two request required for the same date and the higher priority one was below the lower priority one.