Can you bulk link columns?

Options

I know you can bulk link multiple rows by selecting them all during the linking process.

Does this not work the same way with columns?


Thank you,

Cam

Answers

  • KPH
    KPH ✭✭✭✭✭✭
    Options

    If you mean using "Link from Cell in Other Sheet" then yes, you can select multiple columns, right click, choose "Link from Cell in Other Sheet" and select multiple columns in the other sheet.

  • camr
    camr ✭✭
    Options

    When I select multiple cells across columns to link, only the first selection actually links.


    Maybe I'm doing it wrong?

  • Genevieve P.
    Genevieve P. Employee Admin
    edited 10/31/23
    Options

    Hey @camr

    The way I would do this is first right-click on the starting cell that you want to link into. Then in the pop-up window, select the cells either across one row or across a range that you want to link.

    In my example, I've selected the first cell in the Primary column as the one to Cell Link in, then in my range I've selected all the cells from Name1 to F3:

    This then links in all 12 cells in the same order:

    Cheers,

    Genevieve

  • camr
    camr ✭✭
    Options

    Thank you! I was trying to link a set of rows from a summary to a master sheet.

    Seems that doesn't work, but when it's columns in a summary sheet, it does.

    Columns to columns, rows to rows.

    Thanks,

    Cam

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!