My Sheets are heavly Forumula laiden and this, in itself creates an issue insofar as each time I create new rows I have to ensure all my formulas are copied from a blank row.
I'd love to be able to define a formula inside a column that means that the formula is ALWAYS used whenever a new row is inserted etc.