Link an entire column from 1 sheet to another

I know you can do this at the cell level, but is it possible to link an entire column? I'm trying to save the time of linking over 6000 cells and want the ability to grow as I know the numbers will be increasing over time.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    If you are manually adding the row number to the destination sheet, then you really shouldn't have to use the auto-number or anything additional on the source sheet. You can just use a cell reference to refernce the column housing the row number on the destination sheet.

    =INDEX({Other Sheet Column A}, [Row #]@row)

    Using this method, you would either need to add new rows to the destination sheet as new rows are added to the source sheet, or "pre-fill" rows in the destination sheet so that you have more than enough rows for expansion ready to go. Then you can use an IFERROR to leave empty, pre-filled rows blank until they are added to the source sheet.

    =IFERROR({Other Sheet Column A}, [Row #]@row), "")



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!