How to Avoid Blank Rows Copied by Automation
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?
Help Article Resources
Check out the Formula Handbook template!