I have a sheet with columns that look like this:
Spot in Queue Case Number Case Prep Completed Case Completed
1 100 x
2 101 x
Essentially, what I would like to do is change the spot in the queue when the case is completed. For example, when I check off 'Case Completed' for case number 100, the spot in the queue will be blank and case 101 will now be spot 1 in the queue, and case 102 will be spot number 2.
Is there any way to do this? Thank you all!