Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Update Request with "add/subtract" formula to an existing number in a row?
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.