Columns clogging downstream sheets

Eric B.
Eric B. ✭✭✭✭
in Smartsheet Basics

Does anyone know of a way to limit columns moving from one sheet to the next sheet when leveraging Move Rows automation?

I'm finding downstream sheets are getting clogged with unused columns and numerous blank cells. This creates confusion when training new employees, but also creates additional workload for managers who filter and process the final sheets' data.

Is there a way to map which columns I'd like to bring forward?

image.png

Tags:
· Share on FacebookShare on Twitter

Answers

  • KPH
    KPH ✭✭✭✭✭✭

    Hi @Eric B.

    You cannot currently specify which columns are moved/copied using an automation.

    • You could hide the unnecessary columns in the next sheet so no one needs to see them.
    • Another option could be to INDEX/MATCH or VLOOKUP the data you need so it isn't technically moved to the new sheet but does appear there via a formula (and will still remain in the original sheet).
    • A third workaround could be to use an automation to move to a intermediary sheet (to get the data out of the original) and then INDEX/MATCH or VLOOKUP the columns you want into a third sheet.

    You can vote on an enhancement request to enable certain columns to be copied/moved here

    https://community.smartsheet.com/categories/smartsheet-product-feedback-%26-ideas

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video