Copying formulae on sheets where the input is through the forms function

Luke Esdale

Hi Smartsheet team,

My team and I use smartsheet to track our business development opportunities. When we get new leads our team use forms to input the data they need which then adds a new line into our smartsheet doc. However some of the cells in the sheet use currency formulae which do not replicate when we add in a new line. Is there a way to copy the formulae when adding a line from forms?

Thanks

Luke

Andrée Starå

Hi Luke,

To make sure that the formulas work, there have to be at least two rows above or underneath with the same structure/pattern already in the sheet.

https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Make sense? Would that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Ella

To keep the formulas - change your form options to insert new records on top of the sheet instead of at the bottom.