Hello brilliant minds,

I have two sheets Goods Sold and Inventory management that I am struggling to connect as they are interrelated.

The idea is to query the Goods Sold in terms of quantity to Inventory Management under the sheet Input Master.

So I am imagining two ways,

First, Aggregate/Sum all the Quantities sold (Goods Sold) on a particular day and get the input marked as “Out” in the “Inventory In&Out sheet” per product with date and Quantity under the Qty Column.( I have already tried this but breaks constantly with the error: In ARRAY_LITERAL, an Array Literal was missing values for one or more rows.)

Second, any way if I could be to get each record of the Quantity Sold get recorded one by one as “Out” as it happens. (maybe not very lean)

I have tried to do something under “Inventory In&Out” Sheet but it works for a bit and breaks after an hour or so. I am super open to new ideas.

Link to sheets:
Goods Sold: https://docs.google.com/spreadsheets/d/1KQymyUZAyfRZrN4dcWgBiPK_yhw-TWofYO1ChEp0NsU/edit?usp=sharing

Inventory Management: https://docs.google.com/spreadsheets/d/1KQymyUZAyfRZrN4dcWgBiPK_yhw-TWofYO1ChEp0NsU/edit?usp=sharing

A super big thank you in advance!

Already explained above. 🙂