Use a column formula to default a cell value


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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!