Return entire row when value is matched in another sheet

edited 12/09/19 in Smartsheet Basics

I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possible values (in this case, a property). 

What I would like is to have have any rows in the source sheet which match a specific property populate in full in the designated destination sheet I have made for this property. 

The practical application is I have a giant mega list of every item that has gone to every property, but also have individual sheets for each property that only show the data for that property. 

Is this a VLOOKUP function? 


Thank you in advance


  • Hi Dajah!

    It sounds to me like you need to create a report within smartsheet - this will allow you to create individual views based on the 'Property' column that will display all rows related to this value. You can then save one report as a template and use it for other properties by simply changing the filter criteria. The great thing about this solution is that reports and smartsheet on which they are based are linked in both directions, so any changes made in a report will populate to the smartsheet and vice versa. Hope this helps!


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Dajah,

    Maybe it would make sense to use filters instead and then move those rows to the other sheets?

    Would that work?


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.