Return entire row when value is matched in another sheet

Dajah

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

aafek

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!

Anna

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?

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting