Locked Columns Copy/Move Rows
I set up a project where the rows are copied/moved when a trigger is performed. It worked well and all items were moved or copied to the destination sheet. I later changed the destination sheet and locked the columns. The sheet would not copy/move rows to the destination sheet. The destination sheet has locked columns and the original sheet does not, will the copy or move rows automation work?
Best Answer
-
The Copy Row automation should still run and copy data from one sheet to the other, even if the destination sheet has locked columns. This is because you would need to have either Admin or Owner permissions on both sheets in order to set up the Copy Row automation, which are the same permissions required to edit locked columns.
There may be another cause for the copy row not triggering, such as if the trigger is based on a cell link or a cross-sheet formula. (See the note at the bottom of this Help Center article: Trigger Blocks: Define When Your Workflow is Executed)
Would you be able to explain your process and trigger further? It would be helpful to see screen captures of your source and destination sheet, identifying the trigger, and images of the workflow set up, but please block out any sensitive data.
Cheers!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
The Copy Row automation should still run and copy data from one sheet to the other, even if the destination sheet has locked columns. This is because you would need to have either Admin or Owner permissions on both sheets in order to set up the Copy Row automation, which are the same permissions required to edit locked columns.
There may be another cause for the copy row not triggering, such as if the trigger is based on a cell link or a cross-sheet formula. (See the note at the bottom of this Help Center article: Trigger Blocks: Define When Your Workflow is Executed)
Would you be able to explain your process and trigger further? It would be helpful to see screen captures of your source and destination sheet, identifying the trigger, and images of the workflow set up, but please block out any sensitive data.
Cheers!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives