I have a problem, I used Filter Function to pull certain columns to a inventory total item. But I want to have an IF function with it because on the Outgoing Tab there as an input error(Outgoing Tab) that should be not counted on the Inventory Total Item.
Conditions:
Unit Expected: The Item That is pulled out
Units Received: The items that is on hand/On inventory
The Error cause: The item pulled out is much more compared on the Units Received.
For Example: FBA16YF6QQ on Bath Tray should not be counted on the Filter Function because on the Outgoing tab it has an "Input Error" I hope I explained it well. Thank you for the help!
Conditions:
Unit Expected: The Item That is pulled out
Units Received: The items that is on hand/On inventory
The Error cause: The item pulled out is much more compared on the Units Received.
For Example: FBA16YF6QQ on Bath Tray should not be counted on the Filter Function because on the Outgoing tab it has an "Input Error" I hope I explained it well. Thank you for the help!
VA Knowledge (Inventory System) Ebson Bautista.xlsx
Task CREATE A COPY. Do NOT edit directly on here as I am having a few VAs work on this Hello I created this task which should be easy and quick. I just want to see if we can work together and your level of knowledge is good for us. We have a warehouse and we need to know how much inventory is ...
docs.google.com