Hello,
I am doing the asset management.
I am looking for help for formula to update the location in the Master Sheet.
I have items that was being check-out and check-in (rental). So when it is being check-out I want to know where it is located. However, I have the same item that was being check-out (in different time), and I don't think the formula I used is correct.
The mastersheet is Inventory - Asset and the Location column is far to the right.
Thanks.
Bookmarks