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

Cheska Zapata

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!

Jenn Hilber

Column formulas are available now and can be implemented in your sheets. Only Owners and Admins can set, edit, and remove column formulas. A license is required: Individual, Business, Enterprise, and Premier.

Here is a link to the help article.

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas