How to Avoid Blank Rows Copied by Automation

Andy Lorance

Greetings!

I have automation set to automatically copy rows from one sheet to another when certain cells change to 'any value'. The rows are also copied when the value changes from a contact to 'blank'. I can't see to find an effective way to exclude 'blank' entries while still using 'any value' variable. I added a condition (shown below), but it's not working. Any ideas?

Amy Martin

Hi,

For your second condition, is there another column in that row that may also be blank, when GF/F Assign/Reassignment or Super Assign/Reassignment is blank? I used this strategy in a Report, I excluded any blank entry from a cell I knew would be empty unless it was relevant, so things like heading rows were excluded...

I hope that helps... it won't unless you have extra columns!