Hello,
I was wondering if there was a way to record old/initial updates to a cell.
I am trying to record the most recent Z# to the most recent cage cart update. The problem exists when the same cage cart is spotted with a defect.
The sheet on the left contains the carts that we have found to have a defect with the appropriate Z#. While the sheet on the right is a time-stamped user input sheet. The second sheet will contain the Z# tied to the cage cart indicated.
It would be great if I could stop updating the cells on the left after 4 hours (standard processing time). So if the cart is encountered with a defect (left sheet) it will only update with a Z # if the right sheet has a time stamp between today and 4 hours.
The probability of the same cart re-appearing is low, but after enough time it will happen and any previous data will be lost.
=IFERROR(INDEX(COLLECT({LWW Cage Cart Tracker Range 2}, {LWW Cage Cart Tracker Range 4}, [Cart Number (Enter 4-Digit Number)]@row, {LWW Cage Cart Tracker Range 5}, 1), 1), "No match found")
