Column linking

Currently, I am trying to link columns from two sheets in table view. Right now, I can link the columns when I am on the source sheet, e.g., I can match values from the destination sheet to the source sheet. However, when I am on the destination sheet, the column that I want to match to on the destination sheet does not show up. What could be the reason for this

Answers

  • So I see that I can't link to an auto-number, I can only link and auto-number to other data. Basically, I am trying to see if the number in the source sheet matches the auto number in the destination sheet. Is this possible without copying the number in the source sheet, and therefore the row, to the destination sheet

  • prime_nathaniel
    prime_nathaniel ✭✭✭✭✭

    @Benjamin Fanelli not sure I totally understand your situation, but you can dupe auto-number columns in your source to another column in the source just with = formula and then that duplicated column does become available for standard functions

    Principal Consultant | System Integrations

    Prime Consulting Group

    Email: info@primeconsulting.com

    Follow us on LinkedIn!

  • I don't want to duplicate the auto number column, I want to check the other sheet in relation to the auto numbers. Also, I can't use formulas, there are too many columns to do that

  • SSFeatures
    SSFeatures ✭✭✭✭✭✭

    Hi @Benjamin Fanelli,

    Just to give an example of @prime_nathaniel's great point is this:

    Screenshot from 2025-05-30 10-48-34.png

    I duplicated the Auto Number column into a new column named "Auto Number Duplicated", and then this column shows up in the "Link column data" popup.

    If this doesn't work for you, can you include screenshots of your sheets so that I can give a better answer?

    Best!

    Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)

    SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.

  • Screenshot 2025-06-02 082122.png Screenshot 2025-06-02 082027.png

    This is what I want to do. However, Row ID does not appear in the first example because it is an auto number