Add lines in templates and have the formulas auto appear

edited 12/09/19 in Formulas and Functions


So I created this template for our sales team. The idea is that in the yellow boxes they enter item number and quantity (and other things based on where they are in the template) and was informed that there are some sales orders where they will need to add additional boxes.

We were looking to have it set up so that one person in the department has a license and can open the template for the 3 sales people who ideally will have the unlicensed free accounts.

In this template, I have the cells locked that cannot be edited. Generally, they are a mess of formulas and people don’t need to go messing with the formulas and all the dependent linked cells.

So the problem I’m having is that when I add a line in the middle of the formula block it does not add all the formulas automatically (like in excel).  

Is there a way to add a line and automatically have the formulas populate?

Thanks a bunch!

Screen Shot 2019-06-12 at 9.43.50 AM.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!