Adding to Inventory
I'm sure this is simple, but I've searched for a while and haven't found anything similar!
I have a sheet set up to track each piece of marketing collateral. It starts w/ the beginning quantity (say 100 pieces) and deducts the number of pieces that have been requested (through a SS form on another sheet), then another column calculates the quantity remaining.
I have a notification set up to our marketing team to reorder each item once it reaches a certain threshold, but is there a way to send either the marketing team or vendor an update request to input the total amount ordered, and have that amount automatically added to the current inventory available?
Help Article Resources
Check out the Formula Handbook template!