Hi All,
I copied the Tenant Logistics template in Appsheet and want to incorporate it for our Lockers issuance at work. The formula used in google sheets for column Employee ID in the Lockers Sheet was:
=IF(AND(NOT(ISERROR(VLOOKUP(A3, SORT('Move-in'!C:D,-1,FALSE),2,0))),ISERROR(VLOOKUP(VLOOKUP(A3, INDEX(SORT('Move-in'!A:D,2,FALSE),,3),1,0),'Move-out'!D:D,1,0))), VLOOKUP(A3, SORT('Move-in'!C:D,-1,FALSE),2,0), "Available")
So basically, i just want that if i assign this locker to an employee the "Available" status will be changed to the employee ID instead. When the employee resigns or move out of the locker, it will change back to "Available". It's all ok so far...
The problem is when i assign a new employee to that same locker number....it still remains "Available".
I am not sure where the formula went wrong and i need help.
Like for below example:
L001 was previously assigned to Employee ID P-B-23029 (Pls refer to Move-in sheet).
But he already moved out (Pls refer to Move-out sheet)
This L001 was now assigned to Employee ID P-A-23032...but it you look at the Lockers Sheet. It still states "Available" and same case with L002
You might want to remove the sheet formulas and use app formulas instead.
User | Count |
---|---|
28 | |
27 | |
22 | |
13 | |
6 |