Inventory and Logs

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3172965%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EInventory%20and%20Logs%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3172965%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHello.%20I%20am%20trying%20to%20combine%20an%20inventory%20list%20and%20a%20log%20of%20use%20(IE%3A%20user%20uses%20X%20g%20of%20chemicals%2C%20have%20the%20amount%20subtracted%20from%20the%20amount%20registered%20in%20the%20inventory%20list).%20How%20would%20you%20do%20this%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThis%20is%202%20separate%20tables%20(singular%20excel%2C%202%20tabs).%20Some%20chemicals%20there%20are%20smaller%20containers%20in%20different%20locations%2C%20so%20I%20believe%20there%20would%20need%20to%20be%20an%20additional%20calculation%2Finput%20for%20the%20location%20they%20were%20taken%20from.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3172965%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3172965%22%20slang%3D%22en-US%22%3EInventory%20and%20Logs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3172965%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%20I%20am%20trying%20to%20combine%20an%20inventory%20list%20and%20a%20log%20of%20use%20(IE%3A%20user%20uses%20X%20g%20of%20chemicals%2C%20have%20the%20amount%20subtracted%20from%20the%20amount%20registered%20in%20the%20inventory%20list).%20How%20would%20you%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%202%20separate%20tables%20(singular%20excel%2C%202%20tabs).%20Some%20chemicals%20there%20are%20smaller%20containers%20in%20different%20locations%2C%20so%20I%20believe%20there%20would%20need%20to%20be%20an%20additional%20calculation%2Finput%20for%20the%20location%20they%20were%20taken%20from.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3172965%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello. I am trying to combine an inventory list and a log of use (IE: user uses X g of chemicals, have the amount subtracted from the amount registered in the inventory list). How would you do this?

 

This is 2 separate tables (singular excel, 2 tabs). Some chemicals there are smaller containers in different locations, so I believe there would need to be an additional calculation/input for the location they were taken from.

1 Reply

Hi @Meghan_H 

 

could you provide a sample file of your data, so it would be easier for us to understand and give a proper advise.