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



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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!