Hey Everyone,
I'm looking for how to automate a check in/check out process utilizing forms.
What I want:
Tech fills out form with the item's serial number and checks a box for if they're checking in or checking out
This creates a new row in a helper sheet (CHECK OUT)
A master inventory sheet (EQUIPMENT) update's the availability of that item based on matching the serial number
How do I get this to work based on the latest entry for that serial number on the helper sheet?
I tried =INDEX({B6NA CHECK OUT Equipment Inventory Range 1}, MATCH([Barcode Number]@row, {B6NA CHECK OUT Equipment Inventory Range 2}, 0))
{B6NA CHECK OUT Equipment Inventory Range 1} is the checkbox column indicating it's checked in
{B6NA CHECK OUT Equipment Inventory Range 2} is the column containing the serial number
I know this isn't right because if a new entry is added that matches the other criteria and the check in box isn't checked, it isn't unchecking it in the master sheet. I don't understand how to add an IF THEN statement that checks or unchecks based on if the check in box or check out box is checked in the latest entry.
