# What is the best way to combine multiple sheet so that you can retain the sorting and filtering?

I have several projects with multiple action owners. I want to keep the individual sheets for editing, but also combine those sheets into one sheet so that I can allow action owners to filter on their tasks regardless of which sheet it comes from.

##### Post Metadata
- Posted at: over 4 years ago
- Author title: Owner/CEO Changeosity, Director/Partner at EZDAalliance
- Net upvotes: 1


## Comments
### Comment 1

Bring all the sheets together into a Smartsheet Report. Make sure your "action owner" is a contact column type, and in the REPORT filter make sure that owner column is filtered by current user.  

##### Comment Metadata
- Posted at: over 4 years ago
- Author title: Customer Success Manager




## Related Product
[Smartsheet](https://www.g2.com/products/smartsheet/reviews)

## Related Category
[Project Management](https://www.g2.com/categories/project-management)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4