Move Rows Doesn't Work When Cell is Linked?
I am trying to setup a process using Smartsheet and the move row function doesn't seem to work. My process includes 2 sheets:
1. Sheet A
2. Sheet B
When I change a specific cell in Sheet A, there is an automation to copy the row to Sheet B, which works perfect.
Then, I have a DataMesh setup where the Source Sheet is Sheet B, Destination Sheet is Sheet A. The cell linking works perfect, when a cell is updated in Sheet B, it links to Sheet A, that all works great.
The problem is, I then have an Automation in Sheet A to move a row if the linked cell changes to a specific value. When the value changes based on the cell link, it doesn't move the row. When I unlink the cell and manually type the specific value, it moves the row.
Does the Move a Row automation not work if the trigger is a linked cell?
Answers
-
Hi @Kahylin Kelly
Hope you are fine, To prevent infinite approval loops, cells which contain cross-sheet formulas or cell links will not trigger an automation which automatically changes the sheet (Move Row, Copy Row, Lock Row, Unlock Row, Approval Request). To work around this, consider using time-based automation or recurrence workflows.
please read the following article i hope it will help you
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @Kahylin Kelly
Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives