Why is the workflow running at 1am?
I set up a workflow that when a box is checked and it is a certain market, the workflow is to run daily by sending an email to specific group of people to alert that particular box is checked. The boxes are being checked at around 4pm but the automation email is not being sent until 1am or 3am the following day. Am I missing a step?
Trigger: When rows are changed
When: a certain box is checked
Run workflow: Daily
Condition: a certain market
Alert someone: it's getting sent to specific people
I'm wondering if I should run workflow when triggered but afraid the email will be sent multiple times. Or would it not get sent until the spreadsheet is saved so it will send one email?
Best Answers
-
Daily means that it will have to capture the whole day's worth - the sheet does not know that the box checking occurs at 4pm, so it leaves it until the following morning in case you were to (hypothetically) add something at 11:57pm.
If you want the process to run and only capture that day's rows with the box checked, you can alter the trigger to "When Date is Reached" and use the "Custom" to pick Repeat Daily (or pick workdays only on Weekly). This will let you also pick the time (e.g. 5pm). You may need to add additional conditions, but this should help you get started.
-
Daily means all that meet the criteria will run in a batch once a day, and you don't set the time.
What you're wondering is correct. Set it for "when triggered", and it will run/execute the automation within minutes of being saved (but not before it's saved).
Answers
-
Daily means that it will have to capture the whole day's worth - the sheet does not know that the box checking occurs at 4pm, so it leaves it until the following morning in case you were to (hypothetically) add something at 11:57pm.
If you want the process to run and only capture that day's rows with the box checked, you can alter the trigger to "When Date is Reached" and use the "Custom" to pick Repeat Daily (or pick workdays only on Weekly). This will let you also pick the time (e.g. 5pm). You may need to add additional conditions, but this should help you get started.
-
Daily means all that meet the criteria will run in a batch once a day, and you don't set the time.
What you're wondering is correct. Set it for "when triggered", and it will run/execute the automation within minutes of being saved (but not before it's saved).
-
Thank you both! Very helpful :)
-
Happy to help!
All the best to you both!
-Ray
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives