I've got a google form that updates a sheet for locker reservations, on the reservation sheet I have to manually add the locker number and assigned key status. I've got two columns on the main sheet 'Locker Number' and 'Key Status'. We've been running into issues with double checking out keys and I'm trying to find a solution on google sheets to prevent that from happening. I can use data validation to only allow numbers from a list of available lockers that dynamically updates as we add locker numbers to the 'Locker Number' column. Logically I have it planned out but I'm not familiar with the dictionary in sheets to execute it like Id want. When a locker number is entered into the 'Locker Number' column I want to remove the locker from my list of 'Available Lockers' located on another sheet called 'inventory' but only if the 'Key Status' in the same row is not equal to "Key In". If the status is "Key In" I want it to leave the locker number in my list of 'Available Lockers'. enter image description here

  • Locker numbers get assigned at random so its not always true that the first locker checked out will be 1, 2, 3 and so on.
    – joshgebbie
    Feb 17 at 23:08
  • Josh, the likely reason none of the volunteer contributors have answered this post in five days is that you haven't shared a link to a spreadsheet. It's tough to try to create a solution when we can't see all of the parts. So, often, when volunteers here see a post like this, they just move on to another post that does have the full information available. If you still need help, share a link to your spreadsheet (or a copy of it). I'll try to swing back around in 10 or 12 hours to see if you have responded.
    – Erik Tyler
    Feb 22 at 8:25


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.