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?
Help Article Resources
Check out the Formula Handbook template!