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


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?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!