[tylerchurch]

> let's just set a formula for the entire column, and make it refer to another column. And let's name the columns something

If you turn a worksheet section into a proper Table in excel, it does exactly this.