Hi
i am making an app to manage inventory.
i got a database with items and 2 tabs named incoming and out outgoing.
the app is setup to add lines to the incoming and outgoing tabs.
in my database i made a formula in columns with SUMIF and my stock lvl is is those 2 SUMIFโs combined.
this is the formulaโs i use in my sheet.
for incoming โ=SUMIF(Incoming!E:E;B:B;Incoming!B:B)โ
for outgoing โ=SUMIF(outgoing!F:F;B:B;outgoing!C:C)โ
for stock lvl i just do incoming - outgoing.
this is working in the sheet.
appsheet is picking up this formula and showing this.
incoming โSUMIF(Incomming!C[-3]:C[-3],C[-6]:C[-6],Incomming!C[-7]:C[-7])โ
outgoing โSUMIF(outgoing!C[-3]:C[-3],C[-7]:C[-7],outgoing!C[-7]:C[-7])โ
it is showing 0
i hope some one can help me.
thanks in advance.
Hi @Mark Did you check out any of the Inventory sample apps?
Hi @Lynn yes i found one sample app with colors and it was explaining the select formula but that made it even more complicated for me.
my appsheet formula kept giving errors.
most of the inventory appโs i find will change the qty of stock.
i need a record of the items going in and out of stock
i need to keep track of manufacturing date and pallet number for incoming and outgoing.
Hi @Mark One of them has separate sheets/tables for incoming and out going. I will have a look when I get back to my computer.
@Lynn i do not know what happened but appsheet fixed itself somehow and it shows stock and keeps track of all stock changes.
thanks for the the effort.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |