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.
Comments
-
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
-
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?
-
+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?
-
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.
-
Any update on the timeline when this will be fixed is greatly appreciated.
-
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
-
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-requestsHave a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I would also like to export select rows. I hope Smartsheet will add this enhancement.
-
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.
-
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.
-
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.
-
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!
-
Still here...looking for this feature. Stuck creating a bunch of extra sheets for various reports, the opposite of a simplified workflow...
-
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives