Forum Discussion

tintin ting's avatar
tintin ting
Copper Contributor
Aug 04, 2018
Solved

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

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.

  • Hi,

     

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

    In orders items better to select using drop-down list

    Price will be calculated as

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

    The mock-up is attached

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Hi,

     

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

    In orders items better to select using drop-down list

    Price will be calculated as

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

    The mock-up is attached

Resources