Help with Updating Rows Via a Form Submission
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,
Help Article Resources
Check out the Formula Handbook template!