How to automatically put formulas in the new rows that will come in from a form

Options

Hi,

so we have three sheets in the company, and one as a master sheet where it gathers all information from sheet 1,2,3. Everytime I will be inputting a new information on a form, the formula doesn't apply on that new row. is there a way I can automate this that if there is a new row, it will have the formula of the one below it?


Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!