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
-
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.
Answers
-
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.
-
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!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 382 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!