fill down a formula

edited 12/09/19 in Smartsheet Basics

I want to fill down a formula. The formula is a cell in a row from a companion sheet. I want to include the cell in a new sheet and fill down like we do in excel. If we want to hold the reference in excel we add a $ sign to the row and column reference - $A$6 which would hold that cell reference for the rows below.

When I reference a cell (formula) from a companion sheet and fill it down it will not reference each row in the fill but remains locked to the first cell referenced.for example I want to fill down  ={Buyer Tracking Range 2} and have it consecutively reference {Buyer Tracking Range 3} to {Buyer Tracking Range nth}

What is the work around?