How to Avoid Blank Rows Copied by Automation

Options

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?



Answers

  • Amy Martin
    Options

    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!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!