Automated Move Rows won't move anything

I have an automation set to run whenever a "Status" row changed (or row is added) with a condition: "Where Status Contains 'Out of Service'". It's set to alert me, then move rows. It alerts me just fine, but won't move any rows.

Using the row options to move the rows works with ease, and no error messages ever appear.

My trigger works correctly (or at least alerts me correctly), and my destination sheet are set up properly, I'm at a loss for why the rows won't move automatically. Any help?

Find more posts tagged with

Formulas

Automations

Accepted answers

Genevieve P.

Hi @Mogule

How are you changing the Status cell?

Actions that will automatically modify the sheet (such as Move Row) cannot be triggered by inbound cell-links, cross-sheet formulas (or formulas that refer to another cell with an inbound cell link or cross sheet formula).

See the note in this Help Article: Trigger Blocks: Define When Your Workflow is Executed

Instead you could set the trigger for the workflow to be a date-based trigger, such as once a day. See: Create a Time-Based Automated Workflow

Cheers,

Genevieve

All comments

BullandKhmer

OK, I'm confused?

You mean "status" column right?

How can a status column change AND contain "Out of Service' at the same time?

Do you mean when the status column changes to out of service or when the status column changes from out of service?

Genevieve P.

Hi @Mogule

How are you changing the Status cell?

See the note in this Help Article: Trigger Blocks: Define When Your Workflow is Executed

Instead you could set the trigger for the workflow to be a date-based trigger, such as once a day. See: Create a Time-Based Automated Workflow

Cheers,

Genevieve

Mogule

@Genevieve P. The cell is updated via a column formula. (Checks all instances of the ID, collects their statuses, then returns all to the Status cell)

Seems I'm forced in to the time-based trigger

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.