Copy Automation Isn't Completely Working


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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!