Copy Automation Isn't Completely Working

Peelercm

I've set up a list of associates to pull their daily error count.

When the raw total changes from zero, it updates a second sheet that only has these two columns (I have more columns in the original sheet that I don't want pulled for my final sheet, so this is a "helper" sheet).

I've set an automation for this sheet. When column 2 changes to a number greater than 1, it copies to a Request Log.

I tested this automation by entering numbers into the second sheet, and it worked perfectly. But for some reason when numbers are generated in the original sheet it does update the second sheet, but the automation isn't running to update the log.

Paul Newcome

Automations cannot be triggered by a cell that is either linked or contains a cross sheet reference (helps to avoid circular logic breaking things).

You would need to set your automation to be date based (or run daily) and set the criteria to be when that number is greater than zero.

Paul Newcome

Automations cannot be triggered by a cell that is either linked or contains a cross sheet reference (helps to avoid circular logic breaking things).

You would need to set your automation to be date based (or run daily) and set the criteria to be when that number is greater than zero.

Peelercm

Well that's unfortunate, but I guess I understand why. I set up a quick test and it works just fine so far. Thank you!

Paul Newcome

Happy to help. 👍️