Help with Updating Rows Via a Form Submission

Hello,


I am trying to use Smartsheet to track reagents, the workflow is as follows: The person prepping the reagents fills out a form with the pertinent information and the number of vials made. in this example the person made 40 vials. I would like to have this same number decrease via form submission. Example.) 1 vial is used, the person who used the vial submits a form and identifies that 1 vials was used, the number 40 changes to 39. A few weeks later somebody uses 3 vials and indicates that in their form submission, the number changed from 39 to 36. What formula would I use to have this happen/ is this sort of scenario possible?


Thank you so much,


Cameron

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!