Formula to Count Qty from an Order Sheet
I have an order sheet that holds the quantity of an item being ordered. The sheet also shows whether there is enough of the item in stock or not.
If the item is in stock I need to minus the qty from the corresponding item on the stock sheet. If the Item is not in stock, once the job is completed, it needs to add the qty made to the relevant item on the stock sheet.
I think I probably need a few helper columns and some COLLECT formulas somewhere but, I'm happy to share the sheets with anyone that could help.
Help Article Resources
Check out the Formula Handbook template!