Adding to Inventory

edited 12/09/19 in Formulas and Functions
12/03/19 Edited 12/09/19

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?

Best Answer


Sign In or Register to comment.