Way to have multiple people claim an item
Hello. I have a sheet that shows available material that our workers can "claim". I have a formula that populates the Available Quantity after a number is entered into the Quantity Claimed column.
I am looking for a way to have multiple people be able to claim an item if there is Available Quantity left, as well as put their name and job # .
I attached a screenshot to hopefully help show what I am looking for. The simpler the better so we don't have to teach our workers anything super new. Not sure if I would need to change the layout of my sheet or maybe a new formula.
Any help/ideas is appreciated!