export filtered results

gegoe76 · 07/30/18

Hi,

When applying a filter in smartsheet and then exporting the filtered results, it exports the whole sheet included filtered out rows. This is really annoying because in this way the filtering does not help you at all. Can this be fixed please?

Thanks,

Geert.

Shaine Greenwood · 07/31/18

Hi Geert,

As you've found, the entire sheet will be exported even if a filter is applied to the sheet. At this time, there isn't a way to export the filtered view of a sheet. When you have a moment, please submit a product enhancement request using the form under Quick links to the right of the community site to let our Product team know that you'd like to see this functionality added.

One thing that you might try is creating a report to pull in only the data that you want to be exported, then export the report.

More on reports can be found in the help center: https://help.smartsheet.com/articles/522214-creating-reports

More on exporting them is available here: https://help.smartsheet.com/articles/770623-exporting-sheets-reports-from-smartsheet

skhjr · 10/05/18

I have the same problem and it's a bit frustrating. When I export to PDF or send a link to project team members for a sheet it always defaults back to the unfiltered view so there's several pages of closed line items and all I want to convey are the open action items.

There should be an option to retain filters when exporting instead of sending pages of closed/crossed out line items.

Any ideas without creating reports or adding more work to the process?

MichaelLuce · 03/01/19

+1 this is a problem for me too. i need to be able to export filtered results. adding steps to create a report doesn't work for me. ETA of when this fix is coming? or smartsheet isn't interested in addressing our request?

AndreMan · 03/18/19

Same problem here. We export daily deliveries for the next day and only way the data is useful is to resort and manually delete unwanted rows in Excel but that is of course prone to human error.

I will explore the reports option mentioned above and see if that can help.

nthan85831 · 04/17/19

Any update on the timeline when this will be fixed is greatly appreciated.

ajagadis · 07/18/19

Hi Smartsheet Team,

We love the features of Smartsheet. But to make it more effective and have a bigger user base, this Product feature is definitely needed.

For instance, I need to export the results of a Filtered report to a Power BI Dashboard. I have the necessary connectors. But there is no way I can just extract the data that is only needed for the Dashboard.

I will have to export the whole base form of the report, then remove the columns that are not needed. Hence automation which Smartsheet claims with other applications definitely fails.

Is there a way where this feature could be implemented sooner?

Thanks

Andrée Starå · 07/18/19

Hi everyone,

Please submit an Enhancement Request when you have a moment to have your vote added

A New Way to Submit Your Feature Requests

To make your Enhancement / Feature Request count, send in the form above because there isn’t a guarantee, it will be registered otherwise.

Original Post: https://community.smartsheet.com/announcement/new-way-submit-your-feature-requests

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Jan@7101 · 11/01/19

I would also like to export select rows. I hope Smartsheet will add this enhancement.

Anderson · 06/16/20

Another big miss for Smartsheet. What's the point of having a filter view if I can't print it? How do I share it with clients? The more I use this Smartsheet the more I find it is lacking very basic functionality that would be invaluable for its users. It's very disappointing. I've stumbled upon many of these threads searching for desired functionality from years ago that never seem to get addresses. Step it up.

Richard Manning · 03/21/21

Hi guys

New to SmartSheets and found this feed as I was having the same problem. If you filter and then save your sheet then the export will only pick up the filtered rows.

Mark Salamon · 05/19/21

I can't believe that almost 3 years later this very obvious and simple enhancement has not been implemented. I now realize that filters are almost useless.

mbaugher47371 · 04/29/22

So four years later than the first query on this and we still can't export filtered results? Really Smartsheet...that's not smart.

Very disappointing!

mccoy_FSI · 08/08/22

Still here...looking for this feature. Stuck creating a bunch of extra sheets for various reports, the opposite of a simplified workflow...

mccoy_FSI · 08/08/22

Jatin Rathi · 11/12/22

Me too. Its really surprising that this feature has not been implemented even after so many requests. I would again like to request on behalf of everyone to please include this feature in the smartsheet. Thanks.

Smartsheet Basics

Smartsheet Basics

export filtered results

Comments

Quick Links

Categories

Trending in Smartsheet Basics

Has anyone tried to create a trivia game using Smartsheet?

What's the maximum number of rows in a sheet ? Is there any limitation on the number of columns ?

Sharing Permission; Shared Sheet Management for Unlicensed User/Free Collaborator