Hello team!
I'm trying to reference all of the columns from one smart sheet (let's call is smartsheet A) to another (smartsheet B). Here is my formula:
=VLOOKUP([Helper Column]@row, {Smartsheet A}, 7, true)
7 is the location of the helper column in both smartsheet A and smartsheet B. All of the columns in both smartsheets are in the same location.