SOLVED
Home

Inventory input of items that are same price within certain days but different quantity.

%3CLINGO-SUB%20id%3D%22lingo-sub-224285%22%20slang%3D%22en-US%22%3EInventory%20input%20of%20items%20that%20are%20same%20price%20within%20certain%20days%20but%20different%20quantity.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-224285%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EThanks%20for%20reading%20my%20questions.%26nbsp%3B%3C%2FP%3E%3CP%3EMay%20I%20know%20the%20user-friendly%20ways%20to%20input%204%20different%20items%20that%20are%20the%20same%20price%20a%2C%20b%2C%20c%2C%20d%20within%20a%20certain%20period%20of%20time.%20However%2C%20the%20amount%20we%20order%20each%20time%20is%20different.%20It%20should%20have%20a%20date%20column%2C%20an%20item%20column%20(4%20items)%2C%20a%20price%20column%20(4%20different%26nbsp%3Bprices)%20and%20a%20quantity%20column%20(everytime%20is%20different%20for%20the%20same%20item).%20That%20is%2C%20I%20can%20sum%20up%20the%20amount%20I%20spend%20within%20a%20certain%20period%20of%20time%20(price%20x%20quantity%20then%20sum%20up%20the%20cost%20to%26nbsp%3Bbuy%20all%20these%20products%20within%20a%20certain%20time).%26nbsp%3B%20Since%20the%20price%20of%20each%20item%20is%20the%20same%2C%20may%20I%20know%20the%20way%20not%20to%20type%20the%20price%3F%20Is%20it%20relate%20to%20creat%20formula%20or%20many%20different%20ways%20to%20do%20the%20job%3F%26nbsp%3BAny%20trick%20or%20shortcut%3F%20Thanks%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-224285%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eformula%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Einventory%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Epurchase%20order%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-224288%22%20slang%3D%22en-US%22%3ERe%3A%20Inventory%20input%20of%20items%20that%20are%20same%20price%20within%20certain%20days%20but%20different%20quantity.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-224288%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20create%20your%20price%20list%20first%2C%20and%20pick-up%20price%20from%20it%20for%20your%20orders%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20506px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F38968i60DF09C5B86DDC11%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIn%20orders%20items%20better%20to%20select%20using%20drop-down%20list%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20432px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F38969i516E06CAC6EDF13D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPrice%20will%20be%20calculated%20as%3C%2FP%3E%0A%3CPRE%3E%3DIFERROR(INDEX(%24C%244%3A%24C%247%2CMATCH(%24F4%2C%24B%244%3A%24B%247%2C0))%2C%22%22)%3C%2FPRE%3E%0A%3CP%3EThe%20mock-up%20is%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
tintin ting
Occasional Visitor

Hi,

Thanks for reading my questions. 

May I know the user-friendly ways to input 4 different items that are the same price a, b, c, d within a certain period of time. However, the amount we order each time is different. It should have a date column, an item column (4 items), a price column (4 different prices) and a quantity column (everytime is different for the same item). That is, I can sum up the amount I spend within a certain period of time (price x quantity then sum up the cost to buy all these products within a certain time).  Since the price of each item is the same, may I know the way not to type the price? Is it relate to creat formula or many different ways to do the job? Any trick or shortcut? Thanks again.

1 Reply
Highlighted
Solution

Hi,

 

You may create your price list first, and pick-up price from it for your orders

image.png

In orders items better to select using drop-down list

image.png

Price will be calculated as

=IFERROR(INDEX($C$4:$C$7,MATCH($F4,$B$4:$B$7,0)),"")

The mock-up is attached

Related Conversations