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?

Screen Shot 2020-12-15 at 11.25.27 AM.png

Screen Shot 2020-12-15 at 11.29.15 AM.png

Find more posts tagged with

Sheets

Automations

Accepted answers

All comments

Bassam Khalil

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

https://help.smartsheet.com/articles/2479626-automatically-move-or-copy-rows-between-sheets

Bassam Khalil

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.