Adding to Inventory

skarkhoff ✭✭
edited 12/09/19 in Formulas and Functions

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 Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Happy to help! 👍️


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!