Web forms and formulas

Loann McGee

Good afternoon,

I have a simple sheet for a balance sheet, and I'm needing to know if there's a way for the web form submission to be included in the formula in my sheet.

The last row & column of the sheet houses the formula from previous lines, but when the web form submission is added, it goes to a new row, not the last row.

How can I get the formula to do the simple math (add/subtract new row amount from previous row balance)? Or is it possible?

Blessings,
Loann

Kennedy Stomps

Hi Loann-- I think there may be a way to do this, can you share your sheet (or a copy) with me at Kennedy.Stomps@Smartsheet.com so I can take a closer look at what you've got set up? Thanks!