Use a column formula to default a cell value

Jared Agee

I want to use a column formula to automatically input the value of a specific cell into a row field every time a new row is added. Below, I cell link to input the value at "1". Then, I wanted to use a column formula "=[Product Type]$2" to place that value in the project number column. It is giving me a syntax warning when I try to convert the cell formula to a column formula. Thoughts?

Jared Agee

Index / Match… Figured it out…

KPH

You could use

=PARENT([Product Type]@row)