Welcome!

export filtered results

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.

Find more posts tagged with

Comments

Shaine Greenwood

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

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

+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

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

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

ajagadis

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å

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

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

Anderson

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

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

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

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

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

mccoy_FSI

Jatin Rathi

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Not enough space in the cell for my notes
Hi, I'm using smartsheet to track updates on each task in a tracker. These updates may span over a year, so they get lengthy. I was excited about smartsheets because viewing these notes is a lot cleaner. However, I've just realized that there is a content limit to a cell, which is a huge issue. While excel was annoying to…
how can i overlap 2 tasks.
Hello, i've a question about 2 tasks. Task 1 has for example 4 hours and should be on day 1 for example 6 january. Task 2 has 30 hours and should be on start on 4 january and futher. How can i manage that on 6 january task 2 has only 4 hours? Now i got the message user is over-allocated because task 2 is planned on a full…
Update Automations
Hi All, We have several update automations on various solutions - and have worked very well for getting info from people that dont have smartsheet access - how ever in Sept we switched over to SSO and MFA and activated the Safe Share - We have now run into an issue that when our update automations trigger and people within…