Copy Sheet to new sheet & REPLACE/UPDATE) existing data
I have one master Sheet tracking multiple projects.
GOAL
create an exact copy of the sheet (in another folder), however, filtering for only ONE of the projects.
I'm able to use automation "copy sheet", however, any changes, copies over the rows again and again and again....
I need to REPLACE (or update the rows in the new sheet) not add to it every time there is a change.
I notice Automation does not have a "copy and replace" only "copy" or "move".
suggestions?
thanks
Answers
-
The best way to achieve that would be to create a report based on the master sheet filtered to the one project you require.
Changes made to the master or via the report will update both ways and keep one version of the truth.
Is that an option for you?
Hope that helps
Thanks
Paul
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives