Same Value in a column

LeoCicio

I want the values of the columns to be automatically the same all the way down the sheet unless I change the values. As new entries come in from the form it should automatically put in whoever I have listed.

BullandKhmer

Which column is in your form?

Lets assume it is SBN QA Manager.

The Just use =[SBN QA Manager]@row as a column formula in the other 2 columns.

BullandKhmer

Which column is in your form?

Lets assume it is SBN QA Manager.

The Just use =[SBN QA Manager]@row as a column formula in the other 2 columns.

LeoCicio

I had to do something a little different but either way this formula did help answer my question. Thanks