Having a major issue with an Inventory Management App,
Im using an excel document from Dropbox, with 6 tabs “Inventory List, Inwards goods, Outwards Goods, Clients, Suppliers, and Shipping”.
To calculate a current stock level, a in sheet calculation ("=SUMIF(‘Inwards Goods’!D:D,Product,‘Inwards Goods’!E:E)") then added together.
This is working great on the sheet, but the app doesn’t seem to pick up on it.
What are my options?