Adding to Inventory

skarkhoff
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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!