What I'm trying to do is update the current location of an inventory item, based on another sheet's newest row with the same Unit ID.With my AppSheet app, clients order a unit from our inventory, and an employee physically pulls the item and marks it...