A bit new to SS, so this may have an obvious answer, but I'm trying to set up a sheet to track inventory of, say, a dozen products. The initial setup is obviously simple, but then I want to choose the product rows that contain inventory quantities, and set up an automated Update Request to my delivery driver via email each weekday morning (I've got this part working), so he can go through after he picks up for deliveries and simply note the quantity of each product he's delivering for the day, then have the "total on hand" update itself and clear out the cell that has the daily number in it.
I could just have him do the math and subtract the products from the total inventory, but I thought a smarter way to do it was to simply have him note the quantity of each heading out for deliveries for the day, which is a more natural way of thinking about products. We'd also use the same formula/method for adding to inventory on packaging day, once we have new stock to add to inventory, so it'd go both ways, adding or subtracting to the number for each.