Column Formula does not replicate when adding new rows and cannot fill down

We are using a sheet that will need rows added to it constantly and maintain the formulas in multiply columns. We cannot fill down or copy and paste rows. I read somewhere that a function's range won't expand when you add new rows above or below it.

So how do we get the Column Formula to replicate when adding new rows?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!