Trigger Move Automation

Gladys Liley

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

1. formula to number the time a value appears (1, 2, 3, 4, 5, etc) in the Duplicate column
2. 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

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.

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. 👍️