How to save a filtered View in a new sheet?

Chad Holl

We are using a Master Smartsheet that contains all available project Tasks. Some of the Tasks have been nested (hierarchy) multiple levels deep.

When filtered we can then display the tasks required for a specific project. How do you save this filtered view to a new sheet and retain the nesting without the rows now filtered out?

I have tried copying and pasting whole rows and selecting cells, but I either lose the nesting or copy the rows that are hidden (not displayed) by the Filter that are not needed.

Ken Armstrong

You wont be able to make a filtered view the default view but you can try some other things. You can make the filtered a shared filter and communicate that to those that utilize the sheet or you can build a report from the sheet and set it up the same as your filter.

Andrée Starå

Hi @Chad Holl

I hope you're well and safe!

If you have hierarchies, your best option is probably to copy the data manually to a new sheet.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Chad Holl

Im not looking to create a view but a new sheet from the data displayed when the filter is applied. The new sheet would only retain the data from the Master sheet; the hierarchy and not require a filter.

Thanks

Chad H

Chad Holl

https://community.smartsheet.com/discussion/comment/376299#Comment_376299

Although I can select and copy the source data, In the New sheet on a different Tab 'Paste' is grayed out. Any thoughts?