Export selected rows only to excel

NSAN · 11/07/19

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å · 11/07/19

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

Yanina Kupava · 02/25/20

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 · 02/25/20

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

Mark Salamon · 05/19/21

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 · 05/19/21

@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 · 08/12/22

It looks like this feature has been added?

Export selected rows only to excel

Comments

Categories