So pretty simple thing I am doing, pulling data from a form and putting it in a template.
=('Form Responses 1'!B3)
is what I am doing, which works fine for my needs, however when I copy and past this it advances like this
=('Form Responses 1'!B4)
This is working as intended, but I want to advance column instead of the row. Is there an easy way to do this?
What you are looking for is to lock the formula.
The dollar sign
$ is used for "locking" a cell.
Form Responses 1'!$B$3The cell is fully locked.
Form Responses 1'!$B3The column of the cell is locked.
Form Responses 1'!B$3The row of the cell is locked.
Form Responses 1'!B3The cell is unlocked.