Export selected rows only to excel

NSAN

Hello, is it possible to export only the filtered rows to excel? When doing the export, it will hide the rows that were filtered, but they will still be in the excel so if I try to copy and paste or create a mailmerge, the excel will also pick up the hidden rows.

 

Alternatively, is it possible to do a mailmerge via word directly from smartsheets? 

 

Thank you

Andrée Starå

Hi,

Would it work to use a report instead?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Unknown

This content has been removed.

Yanina Kupava

I have the same issue. I need to report externally via an excel and only want to pass along relevant rows based on a filter.

Paul Newcome

You could pull a report that mimics your filter then export that report.

Mark Salamon

The reason a report doesn't work is that filters may be ad hoc. Maybe you want to run a quick search and export just those results.

Also, if you are using dynamic view, you cannot base a report on a dynamic view, but the filters/export relationship work the same way in dynamic view.

SmartSheet, this should be an easy and obvious fix.

Paul Newcome

@Mark Salamon If you create the report and just leave it there, adjusting the report criteria is pretty similar to adjusting sheet filter criteria. Just keep the report, and you can do a quick adjust on that, and you don't have to worry about the sheet itself being saved with the wrong filter or anything.

Mark Salamon

It looks like this feature has been added?

mhoward_ASN

https://community.smartsheet.com/discussion/comment/339456#Comment_339456

Has it? It's 2024 and it still seems to be an issue (for me at least). Mark or anyone, please let us know why you thought it had been added.