I would like to copy rows to another sheet but....
I would like to copy rows to another sheet so that other departments can view /work out of the copied smartsheet. What happens if the master's columns are increased or deleted? Is Smartsheet able to match the rows into the correct columns?
Best Answer
-
Hi @Joanne Marfo ,
If you copy rows to another sheet that sheet becomes a separate data set. Is that what you want?
If you want another department to work with power of your sheet you can use Dynamic View or a report depending on your license. Create a report from your sheet with the columns you want the other group to access. Use criteria to select the rows you want them to access. Changes made to the report populate your sheet and vice versa.
Help?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @Joanne Marfo ,
If you copy rows to another sheet that sheet becomes a separate data set. Is that what you want?
If you want another department to work with power of your sheet you can use Dynamic View or a report depending on your license. Create a report from your sheet with the columns you want the other group to access. Use criteria to select the rows you want them to access. Changes made to the report populate your sheet and vice versa.
Help?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 58 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives