Automation is moving all rows instead of only those that meet the condition

Joseph Pardo

Hi All,

I have automation set up to only move rows where the summary checkbox is checked*.

I added summary 2 and 3 to run more tests since this isn't working correctly. No matter what column I choose for the condition (Summary, Summary 2, Summary 3), it's still moving all the rows.

I have no clue what's happening here so any ideas?

Paul Newcome

In you post you say you want to move rows where the box is not checked, but in the screenshot you have it set to move rows that are checked.

Joseph Pardo

Sorry, I meant move any rows where the summary box is checked, and leave the rows where it's unchecked.

Paul Newcome

And can you show an example of where it moved an unchecked row?

Joseph Pardo

I have all of these rows come over

With the 6 at the bottom where summary is unchecked and it still moves them all when trying to use the original automation I had posted.

So I'm even trying something different where it's using 'copied date + summary' as the condition to move and gives the sheet time to think. So once the 'copied date + summary' changes to unchecked, it's supposed to move those rows.

But it's still moving all of them

Ends up like this still

Joseph Pardo

I created a screen recording of what's happening no matter what column value I use

https://youtu.be/QxaeypbcMXE?si=xF1a804LPLR-dQCb

Paul Newcome

What formula are you using in the [Copied Date + Summary] field?

Joseph Pardo

I'm using this =IF(AND([Copied Date]@row <> "", Summary@row = 1), 0, 1)

Paul Newcome

I'm not sure that formula is working properly then. The way I read it, it should only be checking the box on rows where [Copied Date] is blank and Summary is unchecked, but in other screenshots, it shows rows being checked that do not fit those criteria.

Joseph Pardo

The formula does work properly. I have [Copied Date] <> (not equal) to "" (null). I can filter on that fine, but when I try and use automation to remove the rows that are unchecked, it just removes them all.

Joseph Pardo

I've tried setting up the conditions based on multiple columns, and no matter what it's removing all the rows.

Paul Newcome

Are you using the Run Now feature?

Joseph Pardo

I've tried that, when rows change, when new rows are added, and time based, all with the same result

Paul Newcome

The first automation should be working when you use the Run Now feature. The second automation you provided a screenshot of would move all rows because the Run Now feature ignores triggers and only looks at conditions. Since the second automation does not have a condition, there is nothing for the Run Now feature to filter on.

Joseph Pardo

Right, but no matter what option I use, with conditions or not, it's still moving all the rows. Doesn't matter what's in the condition.

Paul Newcome

You may want to reach out to support.