Automation triggering 1 day later than trigger
Any automated request goes out via email to clients 3 days after a completed date has been entered into a sheet. This was working like a dream for about the last 5 months. Now all of a sudden it goes out 4 days. I can't see anything that has changed. Would you be able to help me pinpoint/fix the problem?
The formulas in the sheet displaying the result for "Days Since Completed":
=IFERROR(NETWORKDAYS([Date Completed]@row, [Todays Date]@row) - 1, "")
Just to reiterate, i haven't made a change to anything. When a cell is showing 3 it doesn't trigger anymore and only triggers when it shows 4.
Thanks
Answers
-
Try deactivating and reactivating it first.
Secondly, you may try recreating the automation from scratch and testing that one out. If it works, activate it and get rid of the current one.
If this is not a solution for you, mark my comment as "Reject" and your question will return to the "Unanswered Questions" queue for others to review. If this does work for you, kindly mark my comment as "Answer", so others can find it in their future searches.
All the best,
-Ray
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives