Trigger Move Automation

Gladys Liley

I have a automation that is not being triggered, here's the setup:

formula to number the time a value appears (1, 2, 3, 4, 5, etc) in the Duplicate column
Move Row automation triggered when there are any add/changes and Condition

a. Duplicate is one of 2, 3, 4, 5

b. Duplicate is not 1

c. Duplicate is equal to or greater than 2

None of these functions are trigger the move. Any suggestions on making this work?

Thank you,

Gladys

Find more posts tagged with

Automations

Accepted answers

Paul Newcome

Let's try checking a box instead of comparing numbers. Change the Duplicate column into a checkbox and use the formula

=IF(COUNTIFS(Name$12:Name@row, Name1, Week$12:Week@row, Week1) >= 2, 1)

Then change the trigger/condition to match Duplicate being checked.

All comments

Paul Newcome

Exactly how are the numbers in the Duplicate column being populated?

Can you provide a screenshot of the automation?

Gladys Liley

Duplicate has a formula:

=COUNTIFS(Name$12:Name@row, Name1, Week$12:Week@row, Week1)

Here's the automation:

Thank you so much for the help!

Paul Newcome

Have you tried changing the trigger from when "any field" change to when "Duplicate" changes?

Gladys Liley

Yes i tried that too. I was thinking that maybe the issue is that the column contains a formula?? Could that be it?

Gladys Liley

Here's the screenshot:

Paul Newcome

Let's try checking a box instead of comparing numbers. Change the Duplicate column into a checkbox and use the formula

=IF(COUNTIFS(Name$12:Name@row, Name1, Week$12:Week@row, Week1) >= 2, 1)

Then change the trigger/condition to match Duplicate being checked.

Gladys Liley

The checkbox formula worked! Rows successfully moved 😀 Thank you!!

Paul Newcome

Happy to help. 👍️

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.