Columns clogging downstream sheets
Eric B.
✭✭✭✭
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?
Tags:
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives