Formula for totaling a sheet cell via a form...

Options

Hi All,

I am struggling to figure out a way, which I hope is ironically simple, to use a form for input data to modify a running total of something.

My riveting scenario is as follows:

I made this nifty form that works well on mobile for employees in the field to provide needed data easily.

My issue is taking this wonderful data from the form and massaging it on the back end to keep a tally of addition and subtraction from and to each location. I want the form to do the heavy lifting.

I hope this makes sense...

Thanks in advance to anyone that is willing to help!


John

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!