Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Referencing External Sheet Data

Is there any way to reference data in another sheet based on a cell's contents? I have inventories that have asset tags and associated serial numbers. I have a separate sheet for maintenance logging. Is it possible to type in an asset tag and have the corresponding serial number auto-fill in the adjacent column? 



  • I too am looking for a way to publish data from one sheet to another based upon a columns data. For example, if column C on Sheet 1 is "Group A" - auto publish that row to exisiting Sheet 2. If Column C on Sheet 1 is "Group B" - auto publish that row to Sheet 3. and so on.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Is the serial number text or a number?

    If the first, not that I know of.

    If the second, yes but very limited functionality.


    We are all hoping for a MATCH or LOOKUP function.

    I hear rumors ...



  • Jonathan White
    edited 06/02/16

    J. Craig,


    It's normally both - depending on the manufacturer. Some examples might include:






    My asset tags are formated as:



    Both the asset tag and serial number are on a row in a specific sheet. It's possible that I could make a master inventory sheet that has all asset tags and related serial numbers (I have different sheets for different venues), so the maintenance list references one sheet instead of 6... I'm just wondering if it's possible to type in an asset tag on the maintenance list and have the SN auto-populate from the asset tag. I know it's possible in Excel but none of the functions that I've tried so far are working....

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭



    No. Based on numerous threads here on the Community, this has to be one of the most requested features.


    However, there are third party tools that can give you that functionality.

    Depending on needs, AppSheet is where I'd start.





  • Hi Jonathan-- 


    Everything Craig has said is correct--we don't currently support MATCH or LOOKUP functions in Smartsheet, but I've added your vote for this to our enhancement request list. 

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Can I get this on a T-Shirt?


    "Everything Craig has said is correct"


    I like the sound of that. I don't believe it, but it sounds nice.



  • Two years later...still nothing.  Pretty much all of our collaborative worksheets are now in Smartsheet.  If I try to do anything "advanced" (very basic in Excel) I always run up against this same response: it's not a feature yet, but we've added your vote.  The fact that so many basic features are still in development makes me wonder what the developers are even working on.  Oh, right, they just released Charts, which is utterly useless (columns have to be next to each other to be used as axes?  Why!).  I'm almost to the point of installing the Live Data Connector so I can just transfer the data from the Smartsheet and actually do useful analysis/charts in Excel.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Did you see the 2018-02-06 release?

This discussion has been closed.