Weekly Automation occurred day late, why?
Hi
I am setting up a system to automatically track the weekly change in a log, and requires more than one sheet to pull off. Timing is very important to ensure the right information gets copied/cleared/used in formulas.
However most of the automation went off without a hitch is seems, except one step failed to trigger at the right time, instead activating a day and four hours later, breaking the whole system.
Any idea why this happened? How to prevent it?
Answers
-
@James Mehrtens Smartsheet can be weird with time zones. I'm guessing you're on the east coast, and your Smartsheet is connecting to west coast servers, and something got messed up. You might want to go in and recreate the automation and delete this one.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Hey James
Jeff is right, smartsheet can have some timezone issues. Typically I bump up against this quirkiness with the system fields (Created or Modified), and only in a specific time window each day. I have seen unexpected results with automations when the sheet owner is in a different timezone and the automation kicks off in their time zone and not mine. Was this the first time you ran your synchronized automations? If they have been running, have you made any changes to the start time? it seems the system would have failed before if no changes have been made.
If the automation was running at midnight it would be easier to explain than this failure at noon.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!