Struggling to Reference future cell data in seperate sheet
I am new to Smartsheet and need help.
I am attempting to take a cell's data (and future data) to populate a seperate sheet. In Excel I would simply enter the following function as an example (=B7*Pricing!E3) then drag the cell function down the column. I see where I can do a manual reference, however, I need this to populate on future data when a new row in the original sheet is populated via forms(without manually creating the reference).
Any help or advice is appreciated.
Help Article Resources
Check out the Formula Handbook template!