Alert and update based on start date, end date and completion %
Hello, I would like to set up the following for a project plan. Reminder to the person assigned in contact column on the day that the task starts (start date). Update Request sent to the same person on the (end date) only if the task is not completed. Can that be done in one work flow, or is that two separate?
Comments
-
Did I not pose this question effectively? No responses?
-
Hi Randy,
We'd use a recurring When a date is reached Trigger and then we'd use two condition paths. One for the Start and one for the End. In the End one, we would also add a Condition to check if the task isn't completed.
Would that work?
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hello Randy,
I was having trouble setting this up in the same workflow, as it sounds like your "Trigger" or the reason for each workflow to be sent is different (one is based on a start date column and one is based on an end date column). I would personally set up two separate workflows:
One workflow would be to send an alert with the trigger being "When a date is reached" specifying that the "Date field" is the Start Date column.
The second workflow would be triggered "When a date is reached" but have the "Date field" be the End Date column, and then as Andree suggested, have a condition that it only runs if the task is not marked "Complete."
You can learn more about creating reminders and update requests via our Help Center:
Thanks!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
I think I have it set with two workflows as described by Genevieve. Thanks!
-
Hi Genevieve,
My thought was to use the recurrence to have it trigger daily/weekly or what's needed, and then it should work.
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Excellent!
Glad you got it working!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andrée,
My apologies, I understand what you mean now. Yes, that would also work, and would keep both notifications within the same workflow.
Thank you for the clarification!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
No worries and no need for an apology!
Happy to help!
Have a fantastic day!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives