When a Web form entry adds a new row to a existing sheet how can you set up that the columns are in

Tyrone Ward

Hello hop I can get some help 

 

we have a sheet we track expenses of field projects that has a basic Sum fuction to add of total cost then links out to a nother sheet for tracking the budject vs actual 

 

if I use a web form it creates a new row 

 

my question how do I get that new row to be adumaticly add the the colom sum function 

 

is it possibel 

 

thanks in advance Tyrone of TMW

ruiovaz

Hi

 

You can use the concept of children formulas, using them in a parent row. Like this, new rows entered at the bottom of the sheet will sum automatically.

Read about it at:

 

https://help.smartsheet.com/articles/775363-using-formulas

 

Hope it helps

 

Rui