How to move specific rows without a helper column
I can't add another column to the main sheet to track which lines have already been moved, but I need to move select lines from four sheets to one other sheet. I have a workflow in place that is moving all of the lines that fit the description, but this is causing duplicates on the destination sheet. Using a report is not an option because we have additional columns on the destination sheet that we must use that do not exist on the original sheets.
How can I move select lines from multiple sheets to a single sheet without duplicating lines?
Answers
-
A few questions that would help with suggestions:
- Why can't you add a column to track what has already been moved?
- This field could then be used to exclude those rows from the source sheet view (by setting a default filter).
- If you're moving the row, then it shouldn't also remain in the source sheet. Is the data duplicated between each of the 4 sheets?
- Why do you need 4 sheets + 1 to track moved rows?
Thoughts:
- To my knowledge, automatic de-duping isn't possible in Smartsheet.
- In this case, it may be easier to consider having one sheet as the "source of truth", replicate the look/feel of the original 4 sheets by building reports, and then recreate any forms used across all 5 sheets into this single sheet.
- Why can't you add a column to track what has already been moved?
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