Quantity deduction workaround
I want to deduct the total "quantity requested" in the "final stock of inventory" after selected the "collected" check box
and also wanted to show the available stock before confirming the order, Please help me with the workaround/ formula to achieve this
Currently I use this formula, =[Initial Stock]@row - IF(Collected@row, 0, SUMIF([Item Name]$1:[Item Name]@row, [Item Name]@row, [Total Quantity Requested]$1:[Total Quantity Requested]@row)) but its not working as expected
Help Article Resources
Check out the Formula Handbook template!